Home > Dynamics Ax > Dynamics Ax – Use the Arithmetic Functions with query classes

Dynamics Ax – Use the Arithmetic Functions with query classes

Dynamics Ax – Using the Arithmetic functions with the query classes. Smile
Query                             query;
QueryBuildDataSource     queryBuildDataSource;
query = new Query();   
queryBuildDataSource = query.addDataSource(TableNum(AssetTrans));
queryBuildDataSource.addSelectionField(FieldNum(AssetTrans,amountMST), SelectionField::SUM);  
queryBuildDataSource.addSelectionField(FieldNum(AssetTrans,revaluationAmount), SelectionField::SUM);  
queryBuildDataSource.addSortField(FieldNum(AssetTrans, transType));   
queryBuildDataSource.addRange(FieldNum(AssetTrans, transDate)).value(queryRange(dateFrom, dateTo));
    return query;
Result of the above Query: Hot SELECT SUM(AmountMST), SUM(RevaluationAmount) FROM AssetTrans GROUP BY AssetTrans.TransType ASC WHERE ((AssetId = FA-000001)) AND ((BookId = COMPUTERS)) AND ((TransDate<=12/31/2153))
Another simple query using the query classes.Tongue out
Query                             query = new Query();  
QueryBuildDataSource     queryBuildDataSource;
QueryBuildRange             queryBuildRange; 
queryBuildDataSource = query.addDataSource(tablenum(PurchParmTable));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(PurchParmTable, Ordering));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(PurchParmTable, PurchId));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(PurchParmTable, ParmJobStatus));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(PurchParmTable, Invoiced));   
These are the simple examples using the query classes. Eye-rolling
Categories: Dynamics Ax
  1. suresh
    July 6, 2012 at 6:04 am

    Thank’s santosh its very useful to me……………..

  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: