Filter on query based on a View

Finance and Operations/AX Developer Forum
1

Hi Friends,

AX Version : AX 2012 R3

I have created a view (CustomerView) which has some inner and outer joined tables, computed fields etc.

Then i have an AOT Query CustomerQuery which is based on this view. When the query is run user is prompted (SysQueryForm as usual) where user can filter the records.

I have field CustGroup in the query which shows records from CustGroup table when lookup is clicked in sysQueryForm. (as this field has EDT relationship)

I have custom field lets say CustomerAreaGroup (similar to custGroup) without EDT relationship, and when the query is run , it doesnt show records from CustomerAreaGroupTable (but from the view).

I want this lookup to show records from CustomerAreaGroupTable.

Any suggestion would be appreciated.

Thanks,

2

Have the field CustomerAreaGroup an EDT? maybe you can create one an assign it on the field, if you don’t want that this EDT be linked on any table , you can create a lookup form an assign to it