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/