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 <ke...@thesorbos.com> wrote: > Is it possible to create a SQL report using a parameter with comma > delimited > ids? > > Specifically I would like to be able to select random, non-contiguous > items. > > 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@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
