Custom lookup on reference group field

(1) Share

Report

Posted on by AbdullahAhmed_

513

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 (5)

Answers (0)

Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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
AbdullahAhmed_ 513 on at

Like (0)

Report
Copy link

Link copied!
Hello martin,

Yes, I should override LookupReference... and you're right that
lookup.addLookupField(fieldNum(PurchAgreementHeader, PurchNumberSequence));

would pick another field from AgreementLine but it was a desperate shot!

any ideas to make that work?

1 people found this reply helpful.

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you want to return fields from different tables and avoid display method, then using a view is a viable option.

Was this reply helpful? Yes No
AbdullahAhmed_ 513 on at

Like (0)

Report
Copy link

Link copied!

Here's the view I created:
I added PurchCommitmentLine_PSN because it's a main datasource in the form!

I get this error: "Could not process the lookupRecord value on the Args instance. The table 'AgreementLine' does not exist as a root FormDataSource for the form 'PurchCommitment_PSN__AgreementLine_SysTCL'."

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please show us your code.

Was this reply helpful? Yes No