Customers more than 1 Sales Order in X++

(0) Share

Report

Posted on by Zeeshan Adeel

335

//The resulting query is equalant to:
//SELECT COUNT(RecId) FROM SalesTable(SalesTable_1)
//GROUP BY SalesTable.CustAccount HAVING ((COUNT(RecId)>1))

static void CustMoreThan1SO(Args _args)
{
Query query = new Query();
QueryBuildDataSource salesDs = query.addDataSource(tableNum(SalesTable));
QueryRun qr;
SalesTable st;
;

salesDs.addSelectionField(fieldNum(SalesTable, RecId), SelectionField::Count);
salesDs.addGroupByField(fieldNum(SalesTable, CustAccount));
query.addHavingFilter(salesDs, fieldStr(SalesTable, RecId), AggregateFunction::Count).value('>1');

qr = new QueryRun(query);
while (qr.next())
{
st = qr.get(tableNum(SalesTable));
info(strFmt("%1 %2", st.CustAccount, st.RecId));
}
}

*This post is locked for comments

I have the same question (0)