Skip to content

Instantly share code, notes, and snippets.

@d47447
Created February 28, 2019 10:08
Show Gist options
  • Select an option

  • Save d47447/75a2fdcbd0cdabb18c7126820442e70e to your computer and use it in GitHub Desktop.

Select an option

Save d47447/75a2fdcbd0cdabb18c7126820442e70e to your computer and use it in GitHub Desktop.
Lookup on form control
public void lookup()
{
Query query = new Query();
QueryBuildDataSource qbds,qbds1;
QuerybuildRange QuerybuildRange,QuerybuildRange1,QuerybuildRange2;
QuerybuildLink QuerybuildLink;
SysTableLookup sysTableLookup;
;
sysTableLookup = SysTableLookup::newParameters(tablenum(UB_ResourceRequest1), this);
sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,ResourceRequestNo), true);
sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,RRStatus), true);
sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,ApprovedNumber),true);
sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,AllocatedNumber),true);
sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,DateOfRequirement),true);
sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,ApprovalStatus),true);
qbds = query.addDataSource(tablenum(ResourceRequest1));
QuerybuildRange = qbds.addRange(fieldnum(ResourceRequest1,RRStatus));
QuerybuildRange1 = qbds.addRange(fieldnum(ResourceRequest1,RRStatus));
QuerybuildRange2 = qbds.addRange(fieldnum(ResourceRequest1,ApprovalStatus));
QuerybuildRange.value(enum2str(RRStatus::Open));
QuerybuildRange1.value(enum2str(RRStatus::Partial));
QuerybuildRange2.value(enum2str(RRWFApprovalStatus::Approved));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
super();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment