blog for Dynamics Axapta

Hi All,

Here i written the code to use the Aggregate functions and Joins inDynamic Query in spite of using normal Select statement in Ax 2009

Normal Select Statement:

while select sum(qty) from inventTrans where inventTrans.ItemId ==

“OL-2500” join inventDimgroup by inventBatchId where

inventDim.InventDimId == inventTrans.InventDimId


// Our Code Here


Dynamic Query:

static void Vasanth_Query_Eg1(Args _args)


Query                   query;

QueryBuildDataSource    queryBuildDataSource;

QueryBuildRange         queryBuildRange;

QueryRun                queryRun;

Qty                     total;

InventTrans             inventTrans;


query = new Query();    queryBuildDataSource    = query.addDataSource(tableNum(InventTrans));




queryBuildRange         = queryBuildDataSource.addRange(fieldNum(InventTrans,ItemId));

queryBuildDataSource    = queryBuildDataSource.addDataSource(tableNum(InventDim));




queryRun = new QueryRun(query);

if (queryRun.prompt())


while (


inventTrans = queryRun.get(tableNum(InventTrans));

total = inventTrans.Qty;



info(strFmt(“Quantity: %1″, total));


Comments on: "Dynamic Query Using Aggregative Functions and Joins" (1)

  1. what is the difference between AddSortFeild & AddOrderByField

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: