Hi Experts,
I need to apply a range in a table method in my code below. How can I achieve it in AX lookup method? In the table HcmWorker I don't have the field reportToWorker instead I have a method named reportToWorker returning the value and I have to add range here to match with my field MyTable.PersonReportTo.
public void lookup(FormControl _formControl,str _filterstr)
{
SysTableLookup sysTableLookup;
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange1;
HcmWorker hcmWorker;
;
sysTableLookup = sysTableLookup::newParameters(tablenum(hcmWorker),_formControl);
sysTableLookup.addLookupfield(fieldnum(hcmWorker,PersonnelNumber));
sysTableLookup.addLookupMethod(tableMethodStr(hcmWorker,Name));
queryBuildDataSource = query.addDataSource(tablenum(hcmWorker));
queryBuildRange1 = queryBuildDataSource.addRange(fieldNum(hcmWorker,reportToWorker()));
queryBuildRange1.value(MyTable.PersonReportTo);
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
