JSON report only contains partial results
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/
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 |----------------------------------------------------------------------------------------| 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> 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 Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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
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@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@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@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 _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Tasha, the caching is done server side, so switching the browser would not make a difference. Try reducing the time the results are cached maybe. There is also a limit on how many results the JSON reports will show. This is set by the SvcMaxreportRows system preference. The default is 10 so that can also explain surprising results. I think changing the LIMIT is just a way to overwrite that preference, so you could do that for individual reports or up the global limit. Hope that helps, Katrin | | On 16.09.21 20:48, Bales (US), Tasha R wrote:
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 Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Alvaro Cornejo -
Bales (US), Tasha R -
Eric Phetteplace -
Katrin Fischer