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@gmail.com] Sent: Thursday, September 16, 2021 12:11 To: Bales (US), Tasha R <tasha.r.bales@boeing.com> Cc: koha@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@boeing.com<mailto:tasha.r.bales@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@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha