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

2023-12-05 Thread 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@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


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

2023-11-29 Thread Cindy Murdock Ames
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