LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Jeffrey Epstein commented on Jeffrey Epstein's album
1 hour ago
Jeffrey Epstein commented on Jeffrey Epstein's album
3 hours ago
S RAVI posted a status
""Call for Chapter Contribution in Editorial Book…"
13 hours ago
S RAVI posted a status
13 hours ago
S RAVI posted a status
"Call for Chapter Contribution in Editorial Book "Introduction to Metrics Studies" https://drive.google.com/drive/home"
14 hours ago
Jeffrey Epstein commented on Jeffrey Epstein's album
21 hours ago
LAITHANGBAM NEPOLEAN SINGH is attending Dr. U. PRAMANATHAN's event
Wednesday
SHWETHA KV updated their profile
Wednesday
Dr. Tarvinder Singh Handa updated their profile
Wednesday
RP Raaj updated their profile
Wednesday
LAITHANGBAM NEPOLEAN SINGH is attending Dr. A. Madhava Rao's event

Online-Lecture on "AI Tools for Academic Research Writing and Publishing" at Microsoft Teams (Online)

August 4, 2025 from 2pm to 4pm
Tuesday
Misbah Ul Huda is attending Dr. A. Madhava Rao's event

Online-Lecture on "AI Tools for Academic Research Writing and Publishing" at Microsoft Teams (Online)

August 4, 2025 from 2pm to 4pm
Monday
Dr. N. Kadiresan updated their profile
Monday
Mukesh Baboo updated their profile
Monday
Abdur Rouf B updated their profile
Monday
Archanagita Saikia updated their profile
Jul 26
RP Raaj shared a profile on Facebook
Jul 24
prema updated their profile
Jul 24
Vikram Jain replied to Vikram Jain's discussion Call for Chapter Contribution in Editorial Book "Artificial Intelligence Connect: Empowering Education & Enabling Libraries"
Jul 24
Abdullah al-Modabber updated their profile
Jul 23

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

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