Hi all, Is this true about the limit of 10 for public report results? Is it documented somewhere? I don't see a mention of it in the manual <https://koha-community.org/manual/21.05/en/html/webservices.html#json-reports-services-label>. We use public reports in a couple of integrations and I've never noticed a limit. I tested just now and was able to over a thousand rows in a public report with no LIMIT statement. I'm just worried that one day my integrations are going to break because of this but right now we're definitely not seeing a limit, or if there is one it's much larger than 10.
Best, ERIC PHETTEPLACE Systems Librarian, Libraries (he/him) [email protected] | o 510.594.3660 (cca) 5212 Broadway | Oakland, CA | 94618 CCA is situated on the traditional unceded lands of the Ohlone peoples. Black-owned bookstores in Oakland: Ashay by the Bay <https://ashaybythebay.com/>, Marcus Books <https://www.facebook.com/marcus.books/> :(){ :|: & };: On Thu, Sep 16, 2021 at 1:07 PM Bales (US), Tasha R < [email protected]> wrote: > Alvaro, thank you so much! Adding the LIMIT fixed my issue. > > Tasha Bales > Enterprise Services > http://isesi.web.boeing.com/ > > From: Alvaro Cornejo [mailto:[email protected]] > Sent: Thursday, September 16, 2021 12:11 > To: Bales (US), Tasha R <[email protected]> > Cc: [email protected] > 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 < > [email protected]<mailto:[email protected]>> 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 > [email protected]<mailto:[email protected]> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
