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 comment