D365FFO – AX – Apply firstonly using query class (QueryRun)

example

static void Job22(Args _args)

{

   Query q = new Query();

   QueryBuildDataSource qbds = q.addDataSource(tablenum(CustTable  ));

   qbds.firstOnly(true);

   SysQuery::findOrCreateRange(qbds,fieldNum(CustTable,AccountNum)).value(‘fdfd’);

   qbds.addOrderByField(fieldNum(CustTable,AccountNum),SortOrder::Descending);

}

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 )

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