public void lookupHCMtable(FormStringControl _ctrl)
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(hcmtable), _ctrl);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
;
sysTableLookup.addLookupfield(fieldnum(hcmtable, EmpId));
sysTableLookup.addLookupfield(fieldnum(hcmtable, EmpName));
queryBuildDataSource = query.addDataSource(tablenum(hcmtable));
queryBuildRange = queryBuildDataSource.addRange(fieldnum(hcmtable, Lastdateworked));
queryBuildRange.value(strFmt('(Lastdateworked > %1)', today()));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(hcmtable), _ctrl);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
;
sysTableLookup.addLookupfield(fieldnum(hcmtable, EmpId));
sysTableLookup.addLookupfield(fieldnum(hcmtable, EmpName));
queryBuildDataSource = query.addDataSource(tablenum(hcmtable));
queryBuildRange = queryBuildDataSource.addRange(fieldnum(hcmtable, Lastdateworked));
queryBuildRange.value(strFmt('(Lastdateworked > %1)', today()));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
No comments:
Post a Comment