X++ code to Count Records in Query

X++ code to Count Records in Query

Following code illustrates how we can use SysQuery::countTotal() method to get the number of records in Query.

static void Query_cntRecords(Args _args)
{
    Query                query = new Query();
    QueryRun             queryRun;
    QueryBuildDataSource qbd;
    ;
    
    qbd = query.addDataSource(tablenum(CustTable));
    queryRun = new QueryRun(query);
    
    info(strfmt("Total Records in Query %1",SysQuery::countTotal(queryRun)));
    
}

Comments

Popular posts from this blog

D365: SSRS Report Development/ Customization

D365: Modifying check report along with the slip text

D365/ Ax2012: X++ code for custom lookup to show customer account and Name