Announcements
No record found.
Hello dears!
I have an AOT query which is a Union query.
Can I get the count value of this AOT query to use the value in a static text form control in a form?
Or I have to write the query as a select statement to get the count and use it on static text form control?
Any advice is appreciated !!!
Thanks in advance !
I don't think the union query is a special case. I haven't tried it, but I think you can get the number of records from the QueryRun object if your fields, relations are correct.
In the examples, he created a query with x . Some rows are not needed as we have AOT query. You can directly use query and queryRun objects
query = new Query(queryStr(MyAOTQuery)); queryRun = new QueryRun(query);
community.dynamics.com/.../count-records-in-query-vs-cound-loops-in-query
I don't know the number of records in the respective tables, but you can make testing easier by adding a simple range (to shrinking the solution set).
Hi Ergün,
Using the SysQuery::CountLoops(qr) or SysQuery::CountTotals(qr) gives me an error with the union query.
The error says:
"There is a field number mismatch in union query. The field number of Table1 is different than the field number of Table2."
And I get this error 10 times since there are 10 datasources in the union query.
I'm using the same query on a grid in a form it works fine. The number of fields for each datarouce do match.
It worked out to create a while(qr.next()) loop and using an integer variable to count the loop.
But I'm not sure if there is a better way to implement this...?
Hi
The person is explaining the same In the below thread.
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 426 Most Valuable Professional
CU10121822-0 358
André Arnaud de Cal... 353 Super User 2026 Season 2
