LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

OKE CHANDAN updated their profile
3 hours ago
jai prakash kumar updated their profile
20 hours ago
Rohidas Rathod updated their profile
yesterday
Rohidas Bhimrao Rathod updated their profile
yesterday
Rohidas Bhimrao Rathod updated their profile
yesterday
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'
Sunday
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
Sunday
Dr.Stephen.G posted a discussion
Sunday
Yogesh Kawale updated their profile
Thursday
Peeyush Dwivedi posted a blog post
Thursday
Ravithimmegowda posted a discussion
Thursday
Ashok Singh updated their profile
Jul 2
jai prakash kumar posted a status
"What are you up to?"
Jul 1
Abhisekh Chetry joined Dr. Badan Barman's group
Jul 1
Abhisekh Chetry joined Dr. Badan Barman's group
Jul 1
Sidhartha Batsya joined Dr. Badan Barman's group
Jun 29
Sidhartha Batsya joined Dr. Badan Barman's group
Jun 29
Dr. U. PRAMANATHAN posted blog posts
Jun 27

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: 1322

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