Colleagues, I want to get a report of all my overdue books; I ran the report yesterday got the printout verified with the shelves and returned a number of books. Running the report again today; I expectedit to remove the patrons who have already returned them but I can still see them on the list. Kindly help. This is the report I used. Overdue materials - *Developer:* Sharon Moreland - SELECT borrowers.surname, borrowers.firstname, borrowers.phone, borrowers.cardnumber, borrowers.address, borrowers.city, borrowers.zipcode, issues.date_due, (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue', items.itype, items.itemcallnumber, items.barcode, items.homebranch, biblio.title, biblio.author FROM borrowers LEFT JOIN issues ON (borrowers.borrowernumber=issues.borrowernumber) LEFT JOIN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) > '30' AND issues.branchcode = <<Issuing branch|branches>>ORDER BY borrowers.surname ASC, issues.date_due ASC
On 03/07/13 09:22, Evan Mungai Njoroge wrote:
I want to get a report of all my overdue books; I ran the report yesterday got the printout verified with the shelves and returned a number of books. Running the report again today; I expectedit to remove the patrons who have already returned them but I can still see them on the list. Kindly help.
This is the report I used.
(Full report at http://wiki.koha-community.org/wiki/SQL_Reports_Library#Overdue_materials ) I think that WHERE maybe should start "WHERE items.onloan IS NOT NULL AND ..." - anyone using this report like to comment? Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/
In Koha system (versions 3.08, 3.10, 3.12) for multi script records (e.g. titles are in Latin, in Cyrillic, in Armenian)after search, when from Relevance drop down menu selecting 'Title (A-Z)' the display for non-Latin records is not in correct order. If for Latin records they are displayed in correct alphabetical order, Armenian and Cyrillic records are mixed, between the records with Armenian titles starting with the letter 'A' you can see records for which the title is starting with the letters 'M', 'H', then again 'A', then Cyrillic records are coming, and after those again records with Armenian letters. Any ideas? thanks Tigran
Hi Tigran! It sounds like your MySql database records are not in true UTF-8. Can you check this? Or your MySql databases collation is not UTF8_general... Best regards Irakli ====================== Irakli Garibashvili Georgian Library Association Address: M. Aleksidse str.1-4, Tbilisi, 0193 Georgia Tel: +(995) 599 109152; + (995-32) 2363413 Fax: + (995-32) 2330135 Email: igar@hotmail.com Http://www.gela.org.ge -------------------------------------------------- From: <tigran@flib.sci.am> Date: Wednesday, July 03, 2013 10:12 PM To: <koha@lists.katipo.co.nz> Subject: [Koha] non-Latin script display in Relevance
In Koha system (versions 3.08, 3.10, 3.12) for multi script records (e.g. titles are in Latin, in Cyrillic, in Armenian)after search, when from Relevance drop down menu selecting 'Title (A-Z)' the display for non-Latin records is not in correct order. If for Latin records they are displayed in correct alphabetical order, Armenian and Cyrillic records are mixed, between the records with Armenian titles starting with the letter 'A' you can see records for which the title is starting with the letters 'M', 'H', then again 'A', then Cyrillic records are coming, and after those again records with Armenian letters. Any ideas? thanks Tigran
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Evan Mungai Njoroge -
Irakli Garibashvili -
MJ Ray -
tigran＠flib.sci.am