This bug may be related as well: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20945 On Tue, Jun 12, 2018 at 7:43 PM Barry, Michael M < Barry.Michael.M@edumail.vic.gov.au> wrote:
I think I've found the source of the problem, I need to specify a ≥1 limitation on 'days overdue' in the box that comes up after running the report, leaving the box blank doesn't work.
Thanks again for the assistance.
Kind regards,
Michael Barry.
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Barry, Michael M Sent: Wednesday, 13 June 2018 9:07 AM To: koha Subject: Re: [Koha] SQL Report not populating
Hi Mark,
I tried running a different saved report (made with the report wizard, to produce a list of patrons by categorycode and sort1 fields) and the results downloaded into the CSV and OpenDocument files fine, so I think it might be something I'm missing in my SQL code.
I replaced my WHERE line with your simplified version and the problem persisted. Opening the CSV file in Notepad yielded the same results: column headings were downloaded, the actual report results were not.
Thanks for your help,
Kind regards, Michael Barry
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Mark Alexander Sent: Wednesday, 13 June 2018 1:11 AM To: koha Subject: Re: [Koha] SQL Report not populating
I tried your query with the WHERE clause slightly simplified to give a non-empty result on my test installation of 18.05:
WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= ''
I was then able to download the CSV file and read it into LibreOffice Calc with no problems.
So your query looks good; maybe take a look at the CSV file in an editor to see if there's anything strange about it. Or perhaps you have to tell your CSV import tool to use commas, and not semicolons or other delimiters (LibreOffice has several options for this). _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
IMPORTANT - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Training. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
IMPORTANT - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Training. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Nick Clemens Sonic Screwdriver (Development Support) ByWater Solutions IRC: kidclamp