Avoid Duplicate values in lookup?

Finance and Operations/AX Technical Forum
1

Dear All,

Based on the field on the form the lookup has to show the data against to that value. The method is working fine but it was showing the Duplicate values. So how can i avoid these duplicate values before showing the lookup here i share my code.

2210.snip.png

Query query = new Query();

QueryBuildDataSource qbds1;

QueryBuildRange qbr;

SysTableLookup sysTableLookup;

;

sysTableLookup = sysTableLookup::newParameters(tablenum(FHREmployeePostingOrders),this);

sysTableLookup.addLookupfield(fieldnum(FHREmployeePostingOrders,Dredger));

sysTableLookup.addLookupfield(fieldNum(FHREmployeePostingOrders,Port));

qbds1 = query.addDataSource(tableNum(FHREmployeePostingOrders));

qbds1.addGroupByField(fieldNum(FHREmployeePostingOrders,Dredger));

qbds1.orderMode(OrderMode::GroupBy);

qbr = qbds1.addRange(fieldNum(FHREmployeePostingOrders,Port));

qbr.value(SysQuery::value(FHREmplDredgeTransfers.Port));

sysTableLookup.parmQuery(query);

sysTableLookup.parmUseLookupValue(true);

sysTableLookup.performFormLookup();

Regards,

Sreekant

2

This problem was already discussed in Custom Lookup and Group By Problem. The outcome was: “Consider setting useLookupValues to false”.