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 < [email protected]> 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:[email protected]] 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:[email protected]] 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 [email protected] > 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 [email protected] > 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Nick Clemens Sonic Screwdriver (Development Support) ByWater Solutions IRC: kidclamp _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
