https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21906 Bug ID: 21906 Summary: WHERE clause doesn't like % in CONCAT Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: cbrannon@cdalibrary.org QA Contact: testopia@bugs.koha-community.org 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.