Filter on ProdTable

Finance and Operations/AX Developer Forum
1

I have to put the filters for inventlocationid on the prodtable form and other two filter were for enum values from the Prodtable that I am able to do … but If i write query for Inventlocationid on the inventdim on Prodtable DS - execute query making a join it does not work …

Is there any other way to filter the records on baisis of the inventlocationid on Prodtable form …

Please suggest …

2

Hi,

There’s a method initMultiSiteFilter() on the prodTable form, just add the following code and the range you want in place of yourRange variable:

QueryBuildRangeLocationId = q.dataSourceTable(tablenum(inventDim)).addRange(fieldnum(InventDim,InventLocationId));
QueryBuildRangeLocationId.value(yourRange);

I works fine for me, let me know if it works for you

regards,

Thomas