[Koha] SQL Report not populating

[Barry, Michael M]

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 at 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 at 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.