如何生成具有多个值的查询。我需要创建仅在网格中显示活动BOM的过滤器,并寻找解决方案。这是我的代码不起作用:
public void executeQuery()
{
QueryBuildRange qbr;
QueryRun queryRun;
Query q = new Query();
qbr = SysQuery::findOrCreateRange(BOMTable_q.dataSourceTable(tableNum(BOMTable)), fieldNum(BOMTable, BOMId));
if (activeButton==false)
{
qbr.value(SysQuery::valueUnlimited());
}
else
{
while select BOMVersion where BOMVersion.Active==true && BOMVersion.Approved==true{
qbr.value(queryValue(BOMVersion.BOMId));
}
super();
你有两种选择:
QueryBuildDataSource qbds = q.dataSourceTable(BOMTable);
QueryBuildRange qbr;
while (...)
{
qbr = qbds.addRange(fieldNum(BOMTable, BOMId));
qbr.value(queryValue(BOMVersion.BOMId));
}
QueryBuildRange qbr = q.dataSourceTable(BOMTable).addRange(fieldNum(BOMTable, BOMId));
container c;
while (...)
{
c+= queryValue(BOMVersion.BOMId);
}
qbr.value(con2str(c));