LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Chavda Jitendra Kumar Ambalal updated their profile
1 hour ago
Chavda Jitendra Kumar Ambalal joined Dr. Badan Barman's group
1 hour ago
Chavda Jitendra Kumar Ambalal joined Dr. Badan Barman's group
1 hour ago
Jeffrey Epstein commented on Jeffrey Epstein's album
11 hours ago
Jeffrey Epstein commented on Jeffrey Epstein's album
13 hours ago
S RAVI posted a status
""Call for Chapter Contribution in Editorial Book…"
23 hours ago
S RAVI posted a status
23 hours ago
S RAVI posted a status
"Call for Chapter Contribution in Editorial Book "Introduction to Metrics Studies" https://drive.google.com/drive/home"
23 hours ago
Jeffrey Epstein commented on Jeffrey Epstein's album
yesterday
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

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