windchill中如何运行带有SQL函数的语句（如select sum（ida2a2） from wtpart）？

Question

这是我的代码

QuerySpec qs = new QuerySpec();
qs.setAdvancedQueryEnabled(true);
int a = qs.appendFrom(new ExternalTableExpression("WTPART"));
String[] aliase = new String[1];
aliase[0] = qs.getFromClause().getAliasAt(a);
TableColumn tc = new TableColumn(aliase[0],"IDA2A2");
SQLFunction sqlf = SQLFunction.newSQLFunction(SQLFunction.SUM);
sqlf.setArgumentAt(tc, 0);
sqlf.getArgumentAt(0);
qs.appendSelect(sqlf, false);

QueryResult qr = PersistenceHelper.manager.find(qs);

    这样运行报下面的错误
    Exception in thread "main" (wt.pds.pdsResource/36) wt.pom.PersistenceException: 带有合计函数的语句不能用于访问控制。
at wt.method.RemoteMethodServer.invoke(RemoteMethodServer.java:791)
at wt.services.ServiceFactory$ClientInvocationHandler.invoke(ServiceFactory.java:349)
at com.sun.proxy.$Proxy0.find(Unknown Source)
at ext.jwis.util.WTPartUtil.test(WTPartUtil.java:724)
at ext.jwis.util.WTPartUtil.main(WTPartUtil.java:136)

有哪个大神帮忙解决一下

Answer 1

https://blog.csdn.net/jasonleezhi/article/details/16871549