[Koha] [EXTERNAL] Re: JSON report only contains partial results

[Bales (US), Tasha R]

Alvaro, thank you so much!  Adding the LIMIT fixed my issue.

Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

From: Alvaro Cornejo [mailto:cornejo.alvaro at gmail.com]
Sent: Thursday, September 16, 2021 12:11
To: Bales (US), Tasha R <tasha.r.bales at boeing.com>
Cc: koha at lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] JSON report only contains partial results
Importance: High


EXT email: be mindful of links/attachments.




Hi Tasha

This is because public reports default to 10 results.

If you need more lines, you should add "LIMIT xxxx" to the end of your query. Where xxx is the maximum lines you want to get.

Regards,

Alvaro
|----------------------------------------------------------------------------------------|
[https://drive.google.com/uc?id=1lpgSKUunPpKrvmS1rja7umnEgiqBa_vD&export=download] Stay safe / Cuídate/  Reste sécurisé
7 Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à mesure.
 q Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire


Le jeu. 16 sept. 2021 à 13:49, Bales (US), Tasha R <tasha.r.bales at boeing.com<mailto:tasha.r.bales at boeing.com>> a écrit :
Any idea why my public report would return almost 2000 results, but the JSON URL for that report (accessed right after I ran the report), would only display a list of 9 results?

I've tried reindexing to no avail.  I've also tried duplicating and rerunning the report, as well as changing the report category back to "Cataloging" instead of the custom category I'd added.

In my initial experimentation with reports and their JSON URL's, everything worked perfectly.  Now, besides the above, I'm noticing odd behavior with the "&annotated=1" parameter, in that if I access the annotated report, then subsequently strip off that parameter and navigate again to the report, the output is still annotated.  I attributed this to caching, but I get this behavior even if I try to access the not annotated URL in a different browser.  That doesn't seem possible; I presume there is something about JSON I just don't understand.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

_______________________________________________

Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha