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

[Eric Phetteplace]

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)

ephetteplace at cca.edu | 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 <
tasha.r.bales at boeing.com> 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: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
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>