LIS Links
First and Largest Academic Social Network of LIS Professionals in India
LIS Links Becoming More Social
Birthdays
Birthdays Today
Latest Activity
UGC-MMTTP Online Two Week Refresher Course in Library and Information Science at RAMANUJAN COLLEGE, UNIVERSITY OF DELHI
August 31, 2026 at 10:30am to September 14, 2026 at 5:30pm
National Conference on "Bharatiya Knowledge System: Bridging Traditional Wisdom and Modern Challenges for Viksit Bharat at Jhunsi,
October 10, 2026 all day
Webinar on DELNET: Resources and Services at Online
September 9, 2026 from 3pm to 4pm
UGC-MMTTP Online Two Week Refresher Course in Library and Information Science at RAMANUJAN COLLEGE, UNIVERSITY OF DELHI
August 31, 2026 at 10:30pm to September 14, 2026 at 5:30pm
72nd ILA Annual Conference – International Conference on “Future Libraries: Advancing Research and Excellence (FLARE 2027)” at Indira Gandhi Memorial Library, University of Hyderabad, Gachibowli
January 7, 2027 to January 9, 2027
*International Conference on Transformative Libraries and the Digital Future – ICTLDF 2026* at ONLINE
August 20, 2026 at 10pm to August 21, 2026 at 7pm
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: 1418
- 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
