LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Tapas Mandal is now a member of LIS Links
yesterday
Welcome Them!
Amar Rithe is now a member of LIS Links
Saturday
Welcome Them!
NAVEEN SATAPPANAVAR updated their profile
Saturday
Manjunatha N is attending Parthasarathivamanan.K's event

International Conference on Transforming Libraries: Innovation, Management, Smart Technologies and Creative Knowledge of Society for the Future at Hybrid Mode (Offline and Online)

December 12, 2025 at 9am to December 13, 2025 at 6pm
Saturday
0 Comments
Manjunatha N updated their profile
Saturday
Dr. Bhakti Gala posted a discussion

Invitation to Participate in an International Survey and Win a Chance to a 2 Year Free ALA Membership

Friday
0 Comments
Profile IconRupam Tamuli and Manashi Devi joined LIS Links
Friday
Dr. Bhakti Gala and Geetanjali Tiwari are now friends
Thursday
Profile IconPallavi Sushant Sapkal, Gorti kartik mahadev and shrddha thomare joined LIS Links
Nov 25
Profile IconShubham Verma, Ranjit Das, Adari P N Lalitha Devi and 1 more joined LIS Links
Nov 23
Surendra Singh is attending Dr. Ashis Biswas's event

ICAL 2026: International Conference on Asian Libraries on Evolving Information Landscape: Making Libraries Future-Ready at IIM, Kashipur, Uttarakhand

April 16, 2026 at 9am to April 18, 2026 at 5pm
Nov 21
0 Comments
Dr. Ashis Biswas posted an event

ICAL 2026: International Conference on Asian Libraries on Evolving Information Landscape: Making Libraries Future-Ready at IIM, Kashipur, Uttarakhand

April 16, 2026 at 9am to April 18, 2026 at 5pm
Nov 21
0 Comments
Profile IconAbhishek shriyal and AMAN SAHU joined LIS Links
Nov 21
Pssprakasarao updated their profile
Nov 21
Profile IconSwati Malvi, S.Francis Selvaraj and Siva M joined LIS Links
Nov 19
Dr. U. PRAMANATHAN posted a blog post

Online applications are invited for the Assistant Professor-Library Science (01) teaching post purely on contractual basis @ Jagat Guru Nanak Dev Punjab State Open University Patiala, Punjab.

Nov 18
0 Comments
Dr.Stephen.G was featured
Congratulate them!
Nov 18
Dr. U. PRAMANATHAN posted a discussion

Ph.D. research study on "Work-Life Balance and Organizational Commitment of Library Professionals in India."

Nov 18
0 Comments
Surendra Singh left a comment for Arnica Kumari
Nov 18
Profile IconAyushi kushwaha, Shyamghan Nayak, Raja Rajeshwari G and 1 more joined LIS Links
Nov 17

Need help in Koha Report

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

Attachments:

▶ Reply to This

Replies to This Forum

Permalink Reply by Ali Raza on May 8, 2016 at 21:13

have u define 952$p in ur marc file

Permalink Reply by Ganesha on May 10, 2016 at 20:39

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

Permalink Reply by Apurba Jyoti Majumder on May 8, 2016 at 21:24 


delete the line 

WHERE items.homebranch ='AVIO'

try this 

ORDER BY biblio.title ASC

instead of 

ORDER BY LPAD(items.barcode,40,' ') ASC
Permalink Reply by Ganesha on May 10, 2016 at 20:50

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

Permalink Reply by Apurba Jyoti Majumder on May 11, 2016 at 15:26

I will check again/...

Permalink Reply by Apurba Jyoti Majumder on May 11, 2016 at 18:32

be in touch in FB

RSS

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp