LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

CHETAN RAVAL updated their profile
yesterday
Bilal Rabbani is now friends with Millan Krushna Dutta and Mhuammad Rafiq Akhtar
Thursday
Vinod Kumar Jain posted a blog post
Thursday
neema shukla posted an event
Thumbnail

International Conference on Libraries and Emerging Technologies for Smart Knowledge Ecosystems (ICLET 2025), at Jaipur,Rajasthan

November 14, 2025 at 9am to November 15, 2025 at 6pm
Thursday
Rohidas Rathod posted an event
Thursday
Hemanta Kumar Biswal posted an event
Thumbnail

4th International Symposium on Knowledge Engineering for Digital Library Design (KEDLD-2025) at Indian Institute of Technology, Kharagpur

November 3, 2025 to November 5, 2025
Thursday
SHIVAKUMARA BC posted a discussion
Thursday
Swati replied to Jayant Deshpande's discussion Librarian are forced to teach a subject
Wednesday
OKE CHANDAN updated their profile
Wednesday
jai prakash kumar updated their profile
Tuesday
Rohidas Rathod updated their profile
Tuesday
Rohidas Bhimrao Rathod updated their profile
Tuesday
Rohidas Bhimrao Rathod updated their profile
Tuesday
Vinod Kumar Jain posted a status
"Required Library paid Intern @ 8000 PM for 6 Months for “Indexing Database”- in Delhi, 9818180051"
Monday
Vinod Kumar Jain posted a status
"Required Library Intern for “Indexing Database”- in Delhi"
Monday
Dr.Stephen.G commented on Dr.Stephen.G's event 'International Conference on Digital and Innovative Advancements for Sustainable Library Services'
Jul 6
Dr.Stephen.G posted an event

International Conference on Digital and Innovative Advancements for Sustainable Library Services at Bharati Vidyapeeth’s Institute of Computer Applications & Management (BVICAM), New Delhi

August 29, 2025 at 10am to August 31, 2025 at 5pm
Jul 6
Dr.Stephen.G posted a discussion
Jul 6
Yogesh Kawale updated their profile
Jul 2
Peeyush Dwivedi posted a blog post
Jul 2

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

Facebook

Views: 1324

Attachments:

Reply to This

Replies to This Forum

have u define 952$p in ur marc file

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.....



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

RSS

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop