Saturday, June 30, 2018

Select count(*) sum(Field) from MyTable

The below select query will give the both the Sales Line record count and the sum of sales quantity.
static void Test_Data(Args _args)
{    
   SalesLine  salesLine;
   select count(RecId),sum(SalesQty) from salesLine;
   info(strFmt("Number of Records : %1  Total Quantity : %2",SalesLine.RecId,SalesLine.SalesQty));
}

Best Regards,
Hossein Karimi

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...