Subscribe to LIS Links Free Alert

Latest Activity

Manmita Baishya posted blog posts
10 hours ago
Preetiranjan Mohanta is now friends with Badan Barman and Himansu shekhar jena
11 hours ago
v.srinivasa rao replied to Dr Deepak Kumar Shrivastava's discussion Dr. D. K. Shrivastava Honoured by Best Young Librarian Award-2018
12 hours ago
Dr. Akhtar Hussain replied to SUMIT CHAKRABORTY's discussion The SC Verdict for Ph.D. Degree Pursued from Distance Mode is Valid and Treated as Equal to Regular Mode.
13 hours ago
Rajashree Patil and Basawaraj Malipatil Gogi are now friends
14 hours ago
Rahul sharma replied to Dr.N.THASLEEM ARIEF's discussion E-Book for NET/SET/JRF Teaching Aptitude
14 hours ago
16 hours ago
DAYAL SINGH BHATI and Vikas saharan are now friends
20 hours ago
DAYAL SINGH BHATI added a page to the group Indian School Library Association (ISLA)


20 hours ago
Sonali Dubey and MD MUSHFIQUE IMAM JAZBI are now friends
20 hours ago
Jeeva and लेखराज मीना are now friends
23 hours ago
Shikha Vaibhav Upasani is now friends with Risabh, Shivam Singh and Basavaraj M. L.

Dear Professional colleagues,

Is there any easy way to know the last Accession Number in Koha other than generating Accession Register Report.

Abdul Gafoor


Views: 470

Reply to This

Replies to This Forum

hello sir try this SQL CODE:

FROM items
homebranch = Pick your branch|branches>>
AND barcode LIKE CONCAT( '%', Partial barcode value here>>, '%')

Thanks my dear friend.

Sir Koha Report about if you need help or if you have any questions ask me....
thank you sir

Thanks my dear for your kindness,

One more thing i would like to know how to generate Accession Register between a particular range. Example -Acc no from 2000 to 3000 or 5000 to 10000 etc. and in ascending order.

Pls guide me,

thanks and regards.

Hello sir,

I have an SQL programme for accession register between two barcodes.

The only problem is it is not sorted by decimal numbering, it gives binary sorting of barcode numbers. I request Murali Krishnan to help us to sort this issue.


SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers,
       items.barcode, items.dateaccessioned, items.itemcallnumber, biblioitems.isbn,, biblio.title, biblioitems.pages,
       biblioitems.publishercode,, biblio.copyrightdate, items.price, items.stocknumber,items.booksellerid, items.location   
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
WHERE items.homebranch =Branch|branches>> AND
items.barcode BETWEEN Barcode from>> AND  Barcode to>> ORDER BY LPAD(items.barcode,40,' ') ASC

 Dear mam

I run the report, as you have directed a slight change is required. some of our professional friends should come to sort out this problem.

thanks and regards


© 2018   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service