Auto Query total Value?  Topic is solved

Discussions relating to the REST API of Jiwa 7.

Auto Query total Value?

Postby SBarnes » Mon Mar 14, 2022 1:01 pm

I thought Auto Queries such as for DB_Main would return in the total property the total records possible that could be available to be able to use with Skip and take but it seems to return zero all the time?
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1619
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: Auto Query total Value?  Topic is solved

Postby Mike.Sheen » Mon Mar 14, 2022 1:05 pm

SBarnes wrote:I thought Auto Queries such as for DB_Main would return in the total property the total records possible that could be available to be able to use with Skip and take but it seems to return zero all the time?


You need to supply the Include=Total parameter - e.g.:

https://api.jiwa.com.au/queries/so_main ... AsRJznB_Ok
AutoQueryTotal.png
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2444
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 756


Return to REST API

Who is online

Users browsing this forum: No registered users and 2 guests