In previous versions of Koha, I have been able to create a field that could have some information or be left blank in the WHERE clause, such as: WHERE itemcallnumber LIKE CONCAT(<<Start of call number>>,'%') Starting with 18.05, Koha will give me results, but it will give me blank results with the header if I download. If I use something else, it will populate in the download just fine. The % seems to be interfering with the download process.
More specifically, the CONCAT does not work in the download now with the % if the field is blank. If I have anything else, it works fine, but displaying and downloading.
If I use CONCAT(IFNULL(<<Gimme>>,""),"%"), it works. Something has changed (only with downloads) that causes the report to barf if the field is blank (null).
I have tried: - Create a new report from SQL SELECT itemnumber, itemcallnumber FROM items WHERE itemcallnumber LIKE CONCAT(<<Start of call number>>,'%') - Execute - Enter "a" => Return 2 results - Export (csv, tab, ods) => Return 2 results on master
(In reply to Jonathan Druart from comment #3) > I have tried: > - Create a new report from SQL > > SELECT itemnumber, itemcallnumber FROM items WHERE itemcallnumber LIKE > CONCAT(<<Start of call number>>,'%') > > - Execute > - Enter "a" > => Return 2 results > - Export (csv, tab, ods) > => Return 2 results > > on master And what happens if you don't fill in the field?
Ha! That was the important bit indeed :)
At first glance it is caused by bug 9634.
(In reply to Jonathan Druart from comment #6) > At first glance it is caused by bug 9634. That would be my guess. It broke after this was introduced.