Announcements
No record found.
Hi I I have lots of records to count on an entity where I need to use 'group by'.
I would rather not use 'while select' as there are millions of records. Is there a more efficient way to do this?
Maybe use a query object?
Thanks
If you use 'group by' and there is a more than a single group, you need a while select (or QueryRun.next() or so) to iterate the groups.
Which version of AX are you talking about, by the way?
Can't we use SysQuery::countTotal
And I am talking about grouping on just one field.
Moved from Dynamics AX Forum.
Unfortunately I have no idea what you need from us, therefore I can't help you. You should provide a better description of your problem.
I have an entity called 'saleslineEnity' and I want to get the the number of salesid's without having to loop through all the records because there are so many. I tried this:
select count(RecId) from salesLinesEntity Group by SalesId
but it doesn't work
I guess I could make a direct call to the database:
str sql = 'select count(distinct Salesid) from salesLineEntity';
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 699
André Arnaud de Cal... 582 Super User 2026 Season 1
Subra 493
