[Koha] View SQL generated by Average Loan Time report?

[Katrin Fischer]

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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha