Filteration of data on form through lookup

Finance and Operations/AX Developer Forum
1

Hi Pioneers,

I have my requirement as below:

In “SalesTable”, I have to put a lookup for “SalesStatus”, as when I select “Open” in lookup, the records in “SalesTable” form, should get filtered with those “SalesOrders”, whose “SalesStatus” is “Open”, if when I select “Invoiced” in lookup, the records in “SalesTable” form, should get filtered with those “SalesOrders”, whose “SalesStatus” is “Invoiced”. I am new to Ax , please guide me.

2

You can override the lookup() method of the data source field (or the form control, if it’s not bound to any data source field) and add a range there. See How to: Add a Lookup Form to a Control.

3

Hi Martin,

Thanks a ton !!!

How many lookups should I write ? For example, should I write a lookup for filteration on the basis of “Open Orders”, “Invoiced Orders” etc. ??? Or may I write “selectionChange()” method ???

4

There is just one lookup method for the field. What you need to do is setting the range value from your parameter. For example:

statusQueryBuildRange.value(queryValue(statusParameter.selection()));