[Koha] SQL Report not populating

[Nick Clemens]

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