Group by on lookup

Hi,

When we need to group by the query values on lookup we need to use parmUseLookupValue(false) method.


public void lookup()
{
    SysTableLookup sysTableLookup;
    Query q = new Query();
    ;
    sysTableLookup  = SysTableLookup::newParameters(tablenum(TableName),this);
    q.addDataSource(tablenum(TableName)).orderMode(OrderMode::GroupBy);
    q.dataSourceTable(tablenum(TableName)).addGroupByField(fieldnum(TableName,FieldName));
    sysTableLookup.addLookupfield(fieldnum(TableName,FieldName));
    sysTableLookup.parmUseLookupValue(false);
    sysTableLookup.parmQuery(q);
    sysTableLookup.performFormLookup();
}

Have a nice coding with AX.