Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(TableTaskCreationRules), this);
TableId tableId;
FieldId fieldId;
;
tableId = tablename2id("TableTaskCreationRules");
fieldId = fieldname2id(tableId, "CreationRule");
sysTableLookup.addLookupfield(fieldId, true);
fieldId = fieldname2id(tableId, "CreationDesc");
sysTableLookup.addLookupfield(fieldId);
fieldId = fieldname2id(tableId, "CreationMode");
sysTableLookup.addLookupfield(fieldId);
queryBuildDataSource = query.addDataSource(tableId);
queryBuildRange = queryBuildDataSource.addRange(fieldNum(TableTaskCreationRules, TaskType));
queryBuildRange.value(enum2str(TaskType::Picking));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(TableTaskCreationRules), this);
TableId tableId;
FieldId fieldId;
;
tableId = tablename2id("TableTaskCreationRules");
fieldId = fieldname2id(tableId, "CreationRule");
sysTableLookup.addLookupfield(fieldId, true);
fieldId = fieldname2id(tableId, "CreationDesc");
sysTableLookup.addLookupfield(fieldId);
fieldId = fieldname2id(tableId, "CreationMode");
sysTableLookup.addLookupfield(fieldId);
queryBuildDataSource = query.addDataSource(tableId);
queryBuildRange = queryBuildDataSource.addRange(fieldNum(TableTaskCreationRules, TaskType));
queryBuildRange.value(enum2str(TaskType::Picking));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();