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
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';
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.
Can't we use SysQuery::countTotal
And I am talking about grouping on just one field.
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?
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156