LIS Links

First and Largest Academic Social Network of LIS Professionals in India

LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Dr. Mohit Banerjee updated their profile
43 minutes ago
M S M Shiham and Frank Morrison are now friends
7 hours ago
M S M Shiham updated their profile
7 hours ago
lavkush agrawal is attending Dr. U. Pramanathan's event

Two day Workshop on Koha on 14-15 December 2024. at KLA Head Quarters, Room No. 36, II Floor, Kairalie Plaza Annexe, Karamana–Killippalam NH, Karamana PO, Thiruvananthapuram–695002. Kerala

December 14, 2024 to December 15, 2024
Dec 10
0 Comments
KHRITISH SWARGIARY updated their profile
Dec 7
Hemanta Gogoi and CAROLINE SARAH are now friends
Dec 5
KHRITISH SWARGIARY posted a status
"What are you up to?"
Dec 5
0 Comments
KHRITISH SWARGIARY left a comment for KHRITISH SWARGIARY
Dec 3
Dr. U. Pramanathan joined Dr. Badan Barman's group
Thumbnail

Sample in Library and Information Science

Dec 3
1 Comment
Profile IconRaghavendra P Inganal and Dr. U. Pramanathan joined Dr. Badan Barman's group
Thumbnail

Circular in Library and Information Science

Dec 2
6 Comments
Saanvi Singh posted a status
"IIT Delhi Assistant Librarian Vacancy: https://shorturl.at/TqkTB"
Dec 2
0 Comments
Urvashi kaushik and Dr. U. Pramanathan are now friends
Dec 1
SIVA PAUL updated their profile
Nov 30
lavkush agrawal joined Dr. Badan Barman's group
Thumbnail

Circular in Library and Information Science

Nov 29
6 Comments
lavkush agrawal is now friends with Karthikeyan C, mohammed muneer, rajesh shukla and sudeep gupta
Nov 29
lavkush agrawal updated their profile
Nov 29
Chandrashekhara N updated their profile
Nov 28
Dr. U. Pramanathan posted a discussion

Membership Options of Society for the Advancement of Library and Information Science (SALIS) through SALIS App:

Nov 28
0 Comments
Dr. U. Pramanathan posted events
1 more…
Nov 28
Dr. U. Pramanathan posted blog posts
10 more…
Nov 28

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

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

© 2024   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop