https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27380 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff --- Comment #5 from Nick Clemens <nick@bywatersolutions.com> --- (In reply to Andrew Fuerste-Henry from comment #4)
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.
Talked with Andrew - I believe the syntax here is simpler and the original plug-in syntax should have been simplified. Sending back to NSO -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.