lookup with not existing value

PHOTO EMBED

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