"Librarian at Seth Anandram Jaipuria School,"
LIS Links
First and Largest Academic Social Network of LIS Professionals in India
Top Content
Birthdays
Birthdays Today
Latest Activity
72nd ILA Annual Conference – International Conference on “Future Libraries: Advancing Research and Excellence (FLARE 2027)” at https://maps.app.goo.gl/D7VYCvyQdyqmyZbn8
January 7, 2027 to January 9, 2027
From Library Automation to Digital Repositories: A 5-Day Hands-on Workshop on Koha & DSpace for LIS Professionals at Online
November 1, 2026 at 7pm to November 5, 2026 at 7pm
Mastering Scholarly Literature Discovery: Indexing, Open Access & Full Text Databases at Online
November 13, 2026 at 7:30pm to November 15, 2026 at 8:30pm
Mastering Scholarly Literature Discovery: Indexing, Open Access & Full Text Databases at Online
November 13, 2026 at 7:30pm to November 15, 2026 at 8:30pm
Need help in Koha Report
Dear Friends,
I am using koha open Source Software in our Library, When i generate report for Accession register am not getting barcode & itemcallnumber in the report. it shows empty , ( I have uploaded bulk data through stage mark record import )
i have used this SQL codes
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 ='AVIO' ORDER BY LPAD(items.barcode,40,' ') ASC
Thanks & Regards
Ganesha
Librarian
Bengaluru
Views: 1442
- Attachments:
-
-
Accession Reg.JPG, 221 KB
-
Replies to This Forum
-
Permalink Reply by Ganesha on
-
Yes,
i am generating report of Checkout and overdue and others am getting barcode of Book, but only in Accession Register Generate am getting above error.....
-
Permalink Reply by Apurba Jyoti Majumder on
-
delete the line
WHERE items.homebranch ='AVIO'
try this
ORDER BY biblio.title ASC
instead of
ORDER BY LPAD(items.barcode,40,' ') ASC
-
-
Hi Sir,
No am getting same Error ,
i am generating report of Checkout and overdue and others am getting barcode of Book, but only in Accession Register Generate am getting above error.....
-
-
I will check again/...
-
-
be in touch in FB
© 2026 Created by Dr. Badan Barman.
Powered by
