Replies to This Forum

Permalink Reply by MURALI KRISHNAN on May 17, 2017 at 16:58

hello sir try this SQL CODE:

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

• ▶ Reply

Permalink Reply by ABDUL GAFOOR on May 17, 2017 at 17:09

Thanks my dear friend.

• ▶ Reply

Permalink Reply by MURALI KRISHNAN on May 17, 2017 at 17:40

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

• ▶ Reply

Permalink Reply by ABDUL GAFOOR on May 17, 2017 at 19:05

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.

• ▶ Reply

Permalink Reply by Chitralekha on May 19, 2017 at 0:01

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.

Chitralekha

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

• ▶ Reply

Permalink Reply by ABDUL GAFOOR on May 19, 2017 at 17:04

 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

• ▶ Reply