LIS Links
First and Largest Academic Social Network of LIS Professionals in India
LIS Links Becoming More Social
Birthdays
Birthdays Today
Latest Activity
One-Day National Seminar on Artificial Intelligence and Academic Libraries: Issues and Opportunities in the 21st Century at kongu arts and science college
October 28, 2026 from 9:30am to 4:30pm
Two-Day Online National Workshop on Library Automation Using Koha at Cooch Behar, West Bengal
October 2, 2026 at 11am to October 3, 2026 at 5pm
Librarianship in the AI Era: A 5-Day Practical Skill Development Programme at Online
October 20, 2026 at 7pm to October 24, 2026 at 7pm
"What are The LIS Portal is a useful platform in the field of Library and Information Science. It helps students, researchers, and librarians"
From Library Automation to Digital Repositories: A 5-Day Hands-on Workshop on Koha & DSpace for LIS Professionals
November 1, 2026 at 7pm to November 5, 2026 at 7pmMastering Scholarly Literature Discovery: Indexing, Open Access & Full Text Databases
November 13, 2026 at 7:30pm to November 15, 2026 at 8:30pm
Top Content
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: 1434
- 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
