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.

CU3 has been released

Cumulative update 3 have been released for Ax 2012

http://blogs.technet.com/b/dynamicsaxse/archive/2012/06/28/announcing-cumulative-update-3-for-microsoft-dynamics-ax-2012.aspx

Microsoft Dynamics Ax2012 R2 release is being expected in Q4 2012

Anniversary

Happy 8 th year in Axapta for me :)

Axapta'da geçen 8 yılım kutlu olsun :)