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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 596 Most Valuable Professional
André Arnaud de Cal... 570 Super User 2025 Season 2
CU05031448-0 556
