Query query = new Query();
QueryBuildDataSource qbds , qbdsCheck;
SysTableLookup _sysTableLookup = SysTableLookup::newParameters(tableNum(PurchReqTable),This);
qbds= query.addDataSource(tableNum(PurchReqTable));
qbds.addRange(fieldNum(PurchReqTable , RequisitionStatus)).value(enum2Str(PurchReqRequisitionStatus::Approved));
qbds.addRange(fieldNum(PurchReqTable , NW_RequestCategory)).value(enum2Str(NW_RequestCategory::RFP_RFQ));
qbdsCheck = qbds.addDataSource(tableNum(PurchRFQCaseTable));
qbdsCheck.addLink(fieldNum(PurchReqTable , PurchReqId) ,fieldNum(PurchRFQCaseTable , PurchReqId));
qbdsCheck.joinMode(JoinMode::NoExistsJoin);
_sysTableLookup.parmQuery(query);
_sysTableLookup.addLookupfield(fieldNum(PurchReqTable, PurchReqId));
_sysTableLookup.addLookupfield(fieldNum(PurchReqTable, PurchReqName ));
_sysTableLookup.performFormLookup();
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter