void initParmDefault() { Query query; QueryBuildDataSource queryBuildDataSource,queryBuildDSProd; QueryBuildRange queryBuildRange,queryBuildRangeStatus; ; super(); query = new Query(); queryBuildDataSource = query.addDataSource(tablenum(InventTable)); queryBuildDataSource.addSelectionField(fieldnum(InventTable, ItemId)); queryBuildRange = queryBuildDataSource.addRange(fieldnum(InventTable, ItemType)); queryBuildRange.value(SysQuery::value(ItemType::BOM)); queryBuildRange.status(RangeStatus::Locked); queryBuildDataSource.addRange(fieldnum(InventTable, itemId)); queryBuildDSProd = queryBuildDataSource.addDataSource(tablenum(ProdTable)); queryBuildDSProd.addSelectionField(fieldnum(prodTable,itemId)); queryBuildRangeStatus = queryBuildDSProd.addRange(fieldnum(ProdTable,ProdStatus)); queryBuildRangeStatus.value(SysQuery::range(ProdStatus::Created,ProdStatus::StartedUp)); queryBuildRangeStatus.status(RangeStatus::Locked); queryBuildDSProd.joinMode(JoinMode::ExistsJoin); queryBuildDSProd.fetchMode(QueryFetchMode::One2One); queryBuildDSProd.addLink(fieldnum(inventTable,itemid),fieldnum(prodTable,itemId)); queryRun = new QueryRun(query); //QueryRun = new QueryRun(querystr(InventTable)); }