Showing posts with label Clear Range and Add Range in ExecuteQuery in Ax 2012.. Show all posts
Showing posts with label Clear Range and Add Range in ExecuteQuery in Ax 2012.. Show all posts

Monday, 17 September 2018

Clear Range and Add Range in ExecuteQuery in Ax 2012.

public void executeQuery()
{
    DimensionMappingTable_DS.query().dataSourceTable(tableNum(DimensionMappingTable)).clearRanges();
    if(TransType.selection() >= 0)
    {
               DimensionMappingTable_DS.query().dataSourceTable(tableNum(DimensionMappingTable))
            .addRange(fieldNum(DimensionMappingTable,Dimensions))
            .value(SysQuery::value(TransType.selection()));
    }

    super();
}