Latest Activity

Dr. U. PRAMANATHAN posted blog posts
11 hours ago
Dr. U. PRAMANATHAN posted discussions
11 hours ago
Dr. Ashis Biswas posted events
12 hours ago
Profile IconAshwini C, PILLI HARSHA, Uchenna Okafor and 3 more joined LIS Links
12 hours ago
Dr. Ashis Biswas might attend Dr. Ashis Biswas's event
Thumbnail

RESCOMM 2025: Research Communication Conclave at Ashoka University

December 17, 2025 at 9am to December 19, 2025 at 6pm
yesterday
Parthasarathivamanan.K posted an event

International Conference at Hybrid Mode (Offline and Online)

December 12, 2025 at 9am to December 13, 2025 at 6pm
yesterday
Dr. Ashis Biswas updated their profile
Wednesday
KUNAL GAURAV updated their profile
Wednesday
Profile IconRajasri Jayavel, SHEEBA S, MD NEYAZ HUSSAIN and 1 more joined LIS Links
Wednesday
A. A. T. Hasan posted a discussion
Monday
SWAPNA SOURAV is now a member of LIS Links
Monday
Dr. Yogesh Subhashrao Kantale updated their profile
Nov 8
Dr. U. PRAMANATHAN posted blog posts
Nov 7
Dr.T.Sureshkumar shared their event on Facebook
Nov 7
Dr.T.Sureshkumar shared their event on Facebook
Nov 7
Dr.T.Sureshkumar posted an event
Nov 6
Profile IconAkash Pathave and Prangyasini Nayak are attending Dr. Jagadish Bujugundala's event

One Day National Workshop on One Nation One Subscription for Research Excellence at Government Degree College, Mulugu,

November 7, 2025 all day
Nov 6
Prangyasini Nayak is attending neema shukla's 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
Nov 6
Dr. U. PRAMANATHAN posted a blog post
Nov 6
shekar.H.P posted an event
Thumbnail

International Conference on Readers are Leaders at Siddaganga Institute of Technology (SIT), Tumkur

February 26, 2026 at 3pm to February 28, 2026 at 6pm
Nov 6

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

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