LIS Links
First and Largest Academic Social Network of LIS Professionals in India
LIS Links Becoming More Social
Birthdays
Birthdays Today
Latest Activity
Applications are invited from eligible candidates for the Librarian posts @ Shri Shivaji Education Society Karad’s, Board for Higher Education, Vidyanagar, Karad.
Advertisement for Resource Centre (Library) Trainees 2025-26 @ Dhirubhai Ambani University (Formerly DA-IICT), Gandhinagar-382 007, Gujarat.
Recruitment for the Post of Library Trainees (Non-academic Position)-Purely on Contractual Basis @ The LNM Institute of Information Technology, Jaipur, Rajasthan.
Final Call for Papers: CALIBER-2025. at Sri Venkateswara University, Tirupati, Andhra Pradesh
Applications are invited for filling up of Library Assistant, Library Attendant, Professional Assistant, Semi Professional Assistant posts under Mizoram University and Pachhunga University College
Advertisement for Deputy Librarian (UR-01) Non-Teaching staff recruitment @ Indian Institute Of Technology–Ropar (IIT–Ropar), Bara Phool, Punjab.
Notice for appointment to the post of Director General on deputation (Including Short-Term Contract) / Contract Basis @ Delhi Public Library (Ministry of Culture, Govt. of India), Delhi.
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: 1317
- 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
© 2025 Created by Dr. Badan Barman.
Powered by
