Dear All,
Open Source Solution not only gives you lot of freedom to customize as per your requirements but it reduces your lot of efforts too with enhanced services of the library. Since many days was working on its Cover flow and public reports feature and found it is one of the best feature of Koha.
You can make public reports and display on OPAC in such a way it will automatically update and users will get updated information about it without interference of Library staff. For example almost many libraries send New arrivals list regularly to their patrons by making list or many manual works, but in Koha you can make public reports for all new books added during specific interval of time, range of acc. no., record no, etc. If you wanted to display it in more beautiful way than take help of Koha Cover flow feature which will display the new arrivals book cover page too. The Koha Cover Flow feature can be used for many purpose like display of popular books, new arrivals, or it can display cover page of all type of reports which you have made.
Some of the links and reports are mention here specially to display New Arrivals:
1. CoverFlow :
2. Koha Public Report :
3. Reports for New Arrival Display
3.1. Catalogue by Accession Number range and sorted by call number
SELECT biblio.author,biblio.title,items.itemcallnumber,items.barcode,isbn
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
WHERE cast(items.barcode AS UNSIGNED) BETWEEN ‘77777’ AND ‘77790’
ORDER BY items.itemcallnumber ASC
3.2. It icludes Author, Title, Call number, Accession number, Record number and ISBN, sorted by record number and shows latest 30 record
SELECT biblio.author,biblio.title,items.itemcallnumber,items.barcode,isbn, biblio.biblionumber
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
where isbn !=” limit 30 order by biblionumber desc
Thank you to Mr. Vimal Kumar Vazhappally, Mr. Ali Raza and Mr. Björn Nyhlén and all persons who helped me to get the work done.
by 