Published by: Vijay Pratap Singh(Team Jivesna Tech)

SELECT items.Dateaccessioned AS 'Accession Date',items.Barcode,biblio.Author,biblio.Title, biblioitems.Publishercode AS 'Publisher',biblio.Copyrightdate AS 'Year', biblioitems.Pages,items.ItemCallnumber AS 'Call No.',biblioitems.ISBN,items.booksellerid AS 'Vendor' ,items.Price,items.ccode,
ExtractValue(items.more_subfields_xml,'//datafield[@tag="999"]/subfield[@code="L"]') AS 'Bill date',
ExtractValue(items.more_subfields_xml,'//datafield[@tag="999"]/subfield[@code="k"]') AS 'Bill no.'
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 <<From Acc. No.>> AND <<To Acc. No.)>>
ORDER BY LPAD(items.barcode,30,' ') ASC

Published by: Vijay Singh

SELECT p.categorycode,p.cardnumber, p.surname, p.firstname,
b.title,, i.barcode,c.date_due
FROM borrowers p
LEFT JOIN issues c ON (p.borrowernumber=c.borrowernumber)
LEFT JOIN items i ON (c.itemnumber=i.itemnumber)
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
WHERE p.cardnumber BETWEEN
<< cardnumber>> AND <<cardnumber>> AND c.date_due IS NOT NULL
ORDER BY p.cardnumber ASC,p.surname ASC, p.firstname ASC, c.date_due ASC

Published by: Jivesna Tech

SELECT b.cardnumber,b.categorycode AS Category,b.sort2,
(SELECT CONCAT('<a href=\"/cgi-bin/koha/members/',b.borrowernumber,'\">', b.surname,', ', b.firstname,'</a>')
FROM borrowers b WHERE b.borrowernumber = a.borrowernumber) AS Patron,
format(sum(amountoutstanding),2) AS 'Amount'
accountlines a, borrowers b
(SELECT sum(amountoutstanding) FROM accountlines a2 WHERE a2.borrowernumber = a.borrowernumber) > '0.00'
AND a.borrowernumber = b.borrowernumber AND b.categorycode = <<Category|categorycode>> BETWEEN
<< BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
a.borrowernumber ORDER BY b.surname, b.firstname, cardnumber ASC

Published by: vikrant

sudo apt-get update
sudo apt-get upgrade
sudo apt-get clean
Download and install the latest Koha release

sudo apt-get install koha-common
sudo a2enmod rewrite
sudo a2enmod cgi
sudo service apache2 restart
sudo nano /etc/apache2/ports.conf
sudo apt-get update
sudo apt-get upgrade
This should generally upgrade your koha-common. However, if the dependencies for koha have increased, you may have to:
$ sudo apt-get install koha-common


Published by: Jivesna Tech

SELECT items.booksellerid, items.barcode, items.dateaccessioned, items.itemcallnumber, biblioitems.isbn,, biblio.title, biblioitems.pages, items.price, biblioitems.editionstatement, biblioitems.publishercode,, biblio.copyrightdate 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.itype= <<Item type code|itemtypes>> ORDER BY LPAD(items.barcode,40,' ') ASC.