Filter the dialog lookup values

Finance and Operations/AX Developer Forum
1

Hi,

In a table voucher_no is allow the duplicate values

I am using that field in report for dialog field, here in dialog look up it should not show the duplicate values

how can I restrict the duplicate values in Dialog lookup

Regards
sunil kumar

2

you can code before sysTableLookup.parmQuery(query);

queryBuildDataSource.orderMode(OrderMode::GroupBy);

queryBuildDataSource.addSortField(fieldnum(Table, Field1));

queryBuildDataSource.addSortField(fieldnum(Table, Field2));

…