Hi Cindy, at the moment it's not possible to see the created SQL query in the GUI, maybe this would be a good idea for an enhancement. But I believe the matrix style reports, like Average loan time, might not be easy to rebuilt in reports as they probably require multiple SQL queries. Katrin On 29.11.23 18:01, Cindy Murdock Ames wrote:
Hi all,
Is there a way to view the query that the Average Loan Time report is using (issues_avg_stats.pl)? I'd like to put it in a SQL report and add further limits to it, it would be handy to be able to dump the query to the screen or log it somewhere.
Thanks! Cindy ----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha