lookup with not existing value
Wed Dec 17 2025 09:07:05 GMT+0000 (Coordinated Universal Time)
Saved by
@MinaTimo
SysTableLookup SysTableLookup = SysTableLookup::newParameters(tableNum(VendPackingSlipJour),_formControl);
QueryBuildDataSource qbds, qbdsCOC;
Query query = new Query();
qbds = query.addDataSource(tableNum(VendPackingSlipJour));
qbds.addRange(fieldNum(VendPackingSlipJour, PurchId)).value(NW_CertificationOfCompletionHeader.PurchId);
//qbds.addRange(fieldNum(VendPackingSlipJour, PackingSlipId)).
// value(SysQuery::valueNot(NW_CertificationOfCompletionHeader.PackingSlipId));
qbdsCOC = qbds.addDataSource(tableNum(NW_CertificationOfCompletionHeader));
qbdsCOC.addLink(fieldNum(VendPackingSlipJour, PackingSlipId),
fieldNum(NW_CertificationOfCompletionHeader, PackingSlipId));
qbdsCOC.joinMode(JoinMode::NoExistsJoin);
SysTableLookup.addLookupfield(fieldNum(VendPackingSlipJour, PackingSlipId),true);
SysTableLookup.addLookupfield(fieldNum(VendPackingSlipJour, PurchId));
SysTableLookup.parmQuery(query);
SysTableLookup.performFormLookup();
}
content_copyCOPY
Comments