How to Know Last Accession Number in Koha - LIS Links2024-03-29T10:01:42Zhttp://lislinks.com/forum/topics/how-to-know-last-accession-number-in-koha?feed=yes&xn_auth=no Dear mam
I run the report, a…tag:lislinks.com,2017-05-20:2013205:Comment:8823752017-05-20T04:04:36.541ZABDUL GAFOORhttp://lislinks.com/profile/ABDULGAFOOR
<p> Dear mam</p>
<p>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.</p>
<p></p>
<p>thanks and regards</p>
<p> Dear mam</p>
<p>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.</p>
<p></p>
<p>thanks and regards</p> Hello sir,
I have an SQL prog…tag:lislinks.com,2017-05-19:2013205:Comment:8824342017-05-19T11:01:33.139ZChitralekhahttp://lislinks.com/profile/ChitralekhaChitale
<p>Hello sir,</p>
<p>I have an SQL programme for accession register between two barcodes.</p>
<p>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.</p>
<p>Chitralekha</p>
<p></p>
<p>SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers, <br></br> items.barcode, items.dateaccessioned,…</p>
<p>Hello sir,</p>
<p>I have an SQL programme for accession register between two barcodes.</p>
<p>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.</p>
<p>Chitralekha</p>
<p></p>
<p>SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers, <br/> items.barcode, items.dateaccessioned, items.itemcallnumber, biblioitems.isbn, biblio.author, biblio.title, biblioitems.pages, <br/> biblioitems.publishercode, biblioitems.place, biblio.copyrightdate, items.price, items.stocknumber,items.booksellerid, items.location <br/>FROM items <br/>LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) <br/>LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) <br/>WHERE items.homebranch =<<Branch|branches>> AND<br/>items.barcode BETWEEN <<Barcode from>> AND <<Barcode to>> ORDER BY LPAD(items.barcode,40,' ') ASC<br/><br/><br/><br/></p>
<p></p> Thanks my dear for your kindn…tag:lislinks.com,2017-05-18:2013205:Comment:8820122017-05-18T06:05:39.245ZABDUL GAFOORhttp://lislinks.com/profile/ABDULGAFOOR
<p>Thanks my dear for your kindness,</p>
<p>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.</p>
<p>Pls guide me,</p>
<p>thanks and regards.</p>
<p></p>
<p>Thanks my dear for your kindness,</p>
<p>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.</p>
<p>Pls guide me,</p>
<p>thanks and regards.</p>
<p></p> Sir Koha Report about if you…tag:lislinks.com,2017-05-18:2013205:Comment:8819092017-05-18T04:40:13.181ZMURALI KRISHNANhttp://lislinks.com/profile/MURALIKRISHNAN96
<pre class="bz_comment_text">Sir Koha Report about if you need help or if you have any questions ask me....<br/>thank you sir<br/><br/></pre>
<pre class="bz_comment_text">Sir Koha Report about if you need help or if you have any questions ask me....<br/>thank you sir<br/><br/></pre> Thanks my dear friend.tag:lislinks.com,2017-05-18:2013205:Comment:8820082017-05-18T04:09:40.873ZABDUL GAFOORhttp://lislinks.com/profile/ABDULGAFOOR
<p>Thanks my dear friend.</p>
<p>Thanks my dear friend.</p> hello sir try this SQL CODE:…tag:lislinks.com,2017-05-18:2013205:Comment:8820752017-05-18T03:58:59.578ZMURALI KRISHNANhttp://lislinks.com/profile/MURALIKRISHNAN96
<p>hello sir try this SQL CODE:</p>
<p>SELECT * <br/>FROM items <br/>WHERE<br/> homebranch = <<Pick your branch|branches>> <br/> AND barcode LIKE CONCAT( '%', <<Partial barcode value here>>, '%')</p>
<p>hello sir try this SQL CODE:</p>
<p>SELECT * <br/>FROM items <br/>WHERE<br/> homebranch = <<Pick your branch|branches>> <br/> AND barcode LIKE CONCAT( '%', <<Partial barcode value here>>, '%')</p>