[Koha] Report: List of books between range of accession numbers

[Ata ur Rehman]

Dear Vimal / All

Please check the SQL below for your required output.


SELECT  CONCAT('<a
href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>')
AS biblionumbers,
items.barcode,items.dateaccessioned,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate
FROM items LEFT JOIN biblioitems ON
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON
(biblioitems.biblionumber=biblio.biblionumber)
WHERE items.homebranch =<<Branch|branches>> AND items.barcode BETWEEN
<<From Acc>> AND <<To Acc)>>
ORDER BY LPAD(items.barcode,30,' ') ASC

Regards,


*Ata ur Rehman** Manager**, Library - NCP*
Tel: (+92-51) 2077-347 | Mobile: (+92-321) 946-2931
www.ncp.edu.pk


On Thu, Oct 18, 2012 at 12:31 AM, Vimal Kumar V. <vimal0212 at gmail.com>wrote:

> Dear Friends,
>
> How can we create a book list between range of accession numbers (100-200).
> It should list books with accession number between 100 to 200.
>
> Regards,
>
> --
> Vimal Kumar V.
> Mahatma Gandhi University Library
> Kottayam, Kerala- 686 560
> Web: http://www.vimalkumar.org
> Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> ---------------------------------------------------------------------------
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>