[Koha-bugs] [Bug 21940] New: Query parameters of the form <<in "foo">> return no results.
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Dec 4 00:55:39 CET 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21940
Bug ID: 21940
Summary: Query parameters of the form <<in "foo">> return no
results.
Change sponsored?: ---
Product: Koha
Version: 18.05
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Reports
Assignee: koha-bugs at lists.koha-community.org
Reporter: barton at bywatersolutions.com
QA Contact: testopia at bugs.koha-community.org
Running the following report
select
cardnumber,
firstname,
surname,
categorycode
from borrowers
where categorycode = <<in "s">>
returns no results. Inspecting 'Show SQL' reveals
select
cardnumber,
firstname,
surname,
categorycode
from borrowers
where categorycode = NULL
however
where categorycode = <<in s>>
and
where categorycode = <<"s">>
both work.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list