[DataSource] class SalesTable { public void executeQuery() { if(this.queryRun() && this.queryRun().query()) { Query userQuery = this.queryRun().query(); QueryBuildRange qbrBatchNumber; QueryFilter qf; QueryBuildDataSource qbdsSalesTable = userQuery.dataSourceTable(tableNum(SalesTable)); QueryBuildDataSource qbdsSalesBatchLink = qbdsSalesTable.childDataSourceNo(1); qf = userQuery.findQueryFilter(qbdsSalesBatchLink,fieldStr(McaSalesBatchLink,batchNumber)); if(qf && qf.value() == SysQuery::valueEmptyString()) { userQuery.clearQueryFilters(qbdsSalesBatchLink,fieldstr(McaSalesBatchLink,batchNumber)); qbrBatchNumber = SysQuery::findOrCreateRange(qbdsSalesBatchLink,fieldNum(McaSalesBatchLink,batchNumber)); qbrBatchNumber.value(SysQuery::valueEmptyString()); } } super(); } }