11 Dec
2017
11 Dec
'17
4:18 p.m.
Hello Kerrie, This should work: Select title, author, i.itemcallnumber from biblio b Left join biblioitems bi on b.biblionumber=bi.biblionumber Left join items i on bi.biblionumber=i.biblionumber where i.barcode IN ("BARCODE1", "BARCODE2", "BARCODE3"); GL, Pedro Amorim On 11 December 2017 at 04:39, SATISH <lis4satish@gmail.com> wrote:
And Barcodes can be searched with wild cards '%' or '_'
eg: 45% results in 45, 451,452,453..459, 4500 this would help you to some extent. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha