Page 1 of 1

What does ReturnTotalCount do in RunQuery?

Posted: December 21st, 2022, 3:35 pm
by CathyC
image.png
image.png (30.54 KiB) Viewed 541 times
image.png
image.png (30.54 KiB) Viewed 541 times
In writing documentation for the runquery in paging, we tried changing it to false, but the logs for the service look the same
image.png
We assumed it was to return the NoOfRecords in the Info node, but that comes back either way. Wondering if its a bug or if its controlling something else

Re: What does ReturnTotalCount do in RunQuery?

Posted: December 21st, 2022, 4:15 pm
by CathyC
discussed with internal team, it should control that and make it not show when set to False.

There might be a case where it is not recommended to keep it on though, so should consider changing the default to false.
This would be a problem in a query against JDE

Needs to be researched

Re: What does ReturnTotalCount do in RunQuery?

Posted: May 9th, 2023, 11:24 am
by CathyC
I have since discussed with Suman. He would like this to default to Off. In the training it is not recommended to leave this on.

It might have been coming back in the logs because when ran during development it forced it to show to help developers? Need to test if changing this to false and running from application will actually stop it from running the 2nd query to get the total count

Re: What does ReturnTotalCount do in RunQuery?

Posted: May 12th, 2023, 11:22 am
by CathyC
Task 11079 was created from another related forum post viewtopic.php?t=568

This change has been implemented as of DesignTime Revision 2575.
Tested and confirmed ReturnTotalCount defaults to False