Re: [Koha] Variables in reports

> I assume that you were talking about the 'Runtime Variables' section of the > wiki: > > https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Variables Yup. > ... Nick, Jesse (pianohacker) and I have all played with this at one time or > another, and I think that our consensus was th

Re: [Koha] Variables in reports

Cab, I assume that you were talking about the 'Runtime Variables' section of the wiki: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Variables ... Nick, Jesse (pianohacker) and I have all played with this at one time or another, and I think that our consensus was that trying t

[Koha] Variables in reports

Hi, All -- We have a report with the following WHERE clause: WHERE b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='KIMBALL') AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 3