public void executeQuery() { ; TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).clearRanges(); if(statusFilter.valueStr() == enum2str(TEC_AllDraftPosted::Draft)) TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).addRange(fieldnum(TECPOGroupHeader,Status)).value(sysquery::value(TECPOGroupStatus::Draft)); if(statusFilter.valueStr() == enum2str(TEC_AllDraftPosted::Posted)) TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).addRange(fieldnum(TECPOGroupHeader,Status)).value(sysquery::value(TECPOGroupStatus::Posted)); //add by fanddy if(statusFilter.valueStr() == enum2str(TEC_AllDraftPosted::Confirmed)) TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).addRange(fieldnum(TECPOGroupHeader,Status)).value(sysquery::value(TECPOGroupStatus::Confirmed)); //END add by fanddy if(CreatorFilter.value() == true) TECPOGroupHeader_ds.query().dataSourceTable(tableNum(TECPOGroupHeader)).addRange(fieldnum(TECPOGroupHeader,CreatedBy)).value(sysquery::value(curUserId())); super(); }
Advertisements