What does ReturnTotalCount do in RunQuery?

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
CathyC
Posts: 472
Joined: November 16th, 2021, 11:15 am
Contact:

What does ReturnTotalCount do in RunQuery?

Unread post by CathyC »

image.png
image.png (30.54 KiB) Viewed 2130 times
image.png
image.png (30.54 KiB) Viewed 2130 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
word count: 68

Tags:
CathyC
Posts: 472
Joined: November 16th, 2021, 11:15 am
Contact:

Re: What does ReturnTotalCount do in RunQuery?

Unread post 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
word count: 54
CathyC
Posts: 472
Joined: November 16th, 2021, 11:15 am
Contact:

Re: What does ReturnTotalCount do in RunQuery?

Unread post 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
word count: 73
CathyC
Posts: 472
Joined: November 16th, 2021, 11:15 am
Contact:

Re: What does ReturnTotalCount do in RunQuery?

Unread post 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
word count: 30
Post Reply