Tuesday, 2 December 2014

Count number of records in a table in AX 2012

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)));
}
at

1 comment:

  1. Blog Comment Backlinks16 June 2021 at 00:30

    thanks for this usefull article, waiting for this article like this again. word counter

    ReplyDelete

Subscribe to: Post Comments (Atom)

Best Practices for Troubleshooting Application Issues in D365 and Power Platform

When facing application issues, it’s important to systematically troubleshoot before reaching out for support.  Follow these steps to ensure...

  • Macros in AX 2012
    Microsoft Dynamics Ax Macros In MorphX macros are not commonly used. A few places make use of macros such as keeping track of the li...
  • Query Build classes in AX 2012
    Introduction The query statement in X++ is a primary method of retrieving and manipulating data in Microsoft Dynamics AX 2012.  A query can...