[Koha-bugs] [Bug 27380] Add option for taking a list parameter in reports

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27380

Andrew Fuerste-Henry <andrew at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #4 from Andrew Fuerste-Henry <andrew at bywatersolutions.com> ---
If your report wraps your parameter in parens like:
WHERE barcode IN (<<Barcodes|list>>)
You end up with the barcodes you entered being parsed as:
WHERE barcode IN (('39999000010113','39999000010114'))
Which gives this error:
The following error was encountered:
The database returned the following error:
Operand should contain 1 column(s)

That's going to confuse anyone coming from the existing plugin, since the
plugin says "To utilise the list functionality syntax should in: VALUE in
(<<List parameter>>)." It requires the extra parens that cause this new patch
to choke.

If we have to train folks not to include those parens, then so be it, but it'd
be great if we could instead teach Koha to deal with them.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.