Saturday, October 9, 2021

AX 2012: Form lookup based on SortField and OrderByField

 public void lookup()

{

    Query query = new Query();

    QueryBuildDataSource queryBuildDataSource;

    QueryBuildRange queryBuildRange;

    SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(AweFinDimMappingView), this);

    sysTableLookup.addLookupField(fieldNum(AweFinDimMappingView, LOB));

    queryBuildDataSource = query.addDataSource(tableNum(AweFinDimMappingView));

    queryBuildDataSource.addSortField(fieldNum(AweFinDimMappingView, LOB));

    queryBuildDataSource.addOrderByField(fieldNum(AweFinDimMappingView, LOB));

    queryBuildDataSource.orderMode(OrderMode::GroupBy);

    sysTableLookup.parmUseLookupValue(false);

    sysTableLookup.parmQuery(query);

    sysTableLookup.performFormLookup();

    //super();

}

No comments:

Post a Comment