Finance | Project Operations, Human Resources, ...

Adding ranges to table methods in look up

(0) Share

Report

Posted on by D365 beginner

582

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();
}

All responses (4)

Answers (0)

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Adding ranges to table methods in look up

Have you solved the issue?

Thanks,

Girish S.
Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Adding ranges to table methods in look up

Then you need to join HcmWorker, HcmPositionWorkerAssignment and HcmPosition table.

Relation will be HcmWorker.RecId == HcmPositionWorkerAssignment .Worker and

HcmPositionWorkerAssignment .Position == HcmPosition.RecId.

Thanks,

Girish S.
D365 beginner 582 on at

Like (0)

Report

RE: Adding ranges to table methods in look up

Thank you Girish for your quick response.

In that case how can I link these two tables ? reportToWorker method is taking value from HCMPositiontable and the look up fields are needed from HcmWorkerTable.
Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Adding ranges to table methods in look up

Hi AX Beginner,

You cannot add the range to the table method. Instead you need to add the table that is used in the reportToWorker method to the lookup query and add range to that.

Thanks,

Girish S.