public void lookup()
{
Query query = new Query();
QueryBuildDataSource qbds;
SysTableLookup sysTableLookup;
sysTableLookup = sysTableLookup::newParameters(tableNum(OMOperatingUnit),this);
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,OMOperatingUnitNumber));
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,Name));
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,OMOperatingUnitType));
sysTableLookup.addSelectionField(fieldNum(OMOperatingUnit,Name));
qbds = query.addDataSource(tableNum(OMOperatingUnit));
qbds.addSortField(fieldNum(OMOperatingUnit,OMOperatingUnitNumber));
qbds.addRange(fieldNum(OMOperatingUnit,OMOperatingUnitType)).value(enum2str(OMOperatingUnitType::OMDepartment));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
{
Query query = new Query();
QueryBuildDataSource qbds;
SysTableLookup sysTableLookup;
sysTableLookup = sysTableLookup::newParameters(tableNum(OMOperatingUnit),this);
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,OMOperatingUnitNumber));
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,Name));
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,OMOperatingUnitType));
sysTableLookup.addSelectionField(fieldNum(OMOperatingUnit,Name));
qbds = query.addDataSource(tableNum(OMOperatingUnit));
qbds.addSortField(fieldNum(OMOperatingUnit,OMOperatingUnitNumber));
qbds.addRange(fieldNum(OMOperatingUnit,OMOperatingUnitType)).value(enum2str(OMOperatingUnitType::OMDepartment));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
Thanks for sharing this informative content , Great work
ReplyDeleteLeanpitch provides online training and certification in Scrum master during this lockdown period everyone can use it wisely.
Scrum master certification
Thanks for sharing this.,
ReplyDeleteLeanpitch provides online training in Scrum Master during this lockdown period everyone can use it wisely.
Join Leanpitch 2 Days CSM Certification Workshop in different cities.
certified scrum master certification