Dynamics Community Forum Thread Details

Filter on account selection

Hi,

I have a requirement where I have a parameter form with a field called "FilterAccountValues" having multiselect lookup seperated by commas, lets say the filter values are:

FilterAccountValues : A-001,C-002,M-001,311

Now when i navigate to "View Trade Agreements" screen from either customers or release products then i should see only the trade agreement with Account selection as FilterAccountValues. i.e. In the account selection field only the values with account selection A-001,C-002,M-001,311 should be displayed.

I tried writing code on PricediscTable formdatasource priceDiscTable - executeQuery()

can someone please help me with code of this.

Thanks in advance.

Categories:

Development / Customization / SDK

Hi,

To which App are you referring to, D365 F&O or another one?

Just one alternative way to achieve similar results.

Have you considered or tried to filter with "is one of" save and publish the view for all appropriate roles? Should be working as in the example I provided in the screenshot (we dont use trade agreements, thats why I used another form).

Developing a solution may not be the most flexible way of implementing the solution as requirements may change. Its generally always safer to keep away from customization. Especially, if something is not working, Microsoft will dont even consider your ticket if you have a custom code in the process.

Both customizaion and a published view maybe messed up if something changes, but a published view can be re-created easily with no effort.

Kind regards, Adis