[Koha] SQL report with Comma Delimited Paramater
barton at bywatersolutions.com
Thu Jun 7 01:17:40 NZST 2018
This is not currently possible, but if you check the bywatersolutions
github page, you can find a plugin called 'koha-plugin-reports-plus', or
something similar (on mobile, or I'd link to it). That plugin will allow
you to add a parameter that lets you enter a list.
On Wed, Jun 6, 2018, 07:38 ksorbo <keith at thesorbos.com> wrote:
> Is it possible to create a SQL report using a parameter with comma
> Specifically I would like to be able to select random, non-contiguous
> The following sql statement works when called directly from mysql:
> *select * from items where barcode in (3456,2346);*
> However, when I create a sql report with the following code:
> *select * from items where barcode in (<<Enter Barcodes>>)*
> it works if I enter 1 barcode, but fails if I enter 2 barcodes separated by
> a comma.
> Is there any workaround for this?
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
More information about the Koha