Friday, 16 January 2015

How to get the count of specific records in x++

To get the count of records in x++, see the example given below. Here, in an AX job, we are getting count of all the sales orders that belong to a specific customer account.


static void JobCount(Args _args)
{
    SalesTable salesTable;
       
    select  count(RecId) from salesTable
    where salesTable.CustAccount == '1101';

    info(strFmt('%1',salesTable.RecId));    // Display the count value.
}

2 comments:

  1. cloud data engineer coursecourse
    Enroll in a Google Cloud Course with on‑demand lessons, real labs, and skill badges to build job‑ready cloud skills across compute, data, and AI.

    ReplyDelete
  2. Learn Salesforce Lightning Online Training with hands-on modules covering Lightning App Builder, LWC fundamentals, component composition, navigation, and performance.
    learn salesforce lightning web components

    ReplyDelete