How to count and sort records using axapta query?

Question

I want to count how many records are there in CustTable (group by CustGroup) and sort the number of records in each custgroup descending using query code.

here is my code:

q = new Query();
queryBuildDataSource = q.addDataSource(tableNum(custTable));
queryBuildDataSource.addGroupByField(fieldNum(custTable, CustGroup));
//queryBuildDataSource.addSortField(fieldNum(custTable, count(RecId), SortOrder::Descending));
qr = new QueryRun(q);
while(qr.next())
{
   custTable = qr.get(tableNum(custTable));
   info(strFmt("%1 --- %2", custTable.CustGroup, custTable.RecId));
}

I know that 'count' does not work here... how can I solve it?

What is the difference between this and your previous question? stackoverflow.com/questions/22246734/… — Jan B. Kjeldsen
– Jan B. Kjeldsen, Commented Mar 18, 2014 at 11:47

Community · Accepted Answer · 2017-05-23 12:20:52Z

2

You cannot (in X++) sort on an aggregated field.

What you can do is make a view, then sort on its output explained in this answer and here.

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Mar 18, 2014 at 11:44

Jan B. Kjeldsen

18.1k5 gold badges36 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to count and sort records using axapta query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related