Custom lookup on reference group field

(0) Share

Report

Posted on by AbdullahAhmed_

432

Hi..

I have this out of the box lookup that has Purchase agreement field not filterable!

I tried to develop a custom lookup using different ways:

1- use a table method

But The Purchase agreement field is empty.. it only shows values if I made the getPurchNumberSequence a display method.. but again I'm not able to apply filter!

2- add a custom query... it doesn't work and the column PurchNumberSequence doesn't appear at all

3- create a view that has the desired fields but it gives the error: AgreementLine isn't a form primary datasource

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Martin Dráb 236,477 Most Valuable Professional on at

Like (0)

Report
Custom lookup on reference group field

Your attempt to use fields from different tables in addLookupField() is wrong. addLookupField() adds fields from the table that the SysReferenceTableLookup object was created for.

For example, look at this code:

lookup = SysReferenceTableLookup::newParameters(tableNum(AgreementLine), ... lookup.addLookupField(fieldNum(PurchAgreementHeader, PurchNumberSequence));

You believe it adds PurchAgreementHeader.PurchNumberSequence, but in fact, it adds a field from AgreementLine that happen to have the same ID that PurchNumberSequence has in PurchAgreementHeader table. That's clearly wrong.

Also, shouldn't you override FormReferenceControl.lookupReference() instead of lookup()?

Was this reply helpful? Yes No