Bug 2866

Summary: Filtering and sorting the overdue report using patron attributes
Product: Koha Reporter: Rick Welykochy <rick>
Component: CirculationAssignee: Galen Charlton <gmcharlt>
Status: CLOSED FIXED QA Contact:
Severity: enhancement    
Priority: PATCH-Sent (DO NOT USE) CC: nengard
Version: Main   
Hardware: All   
OS: All   
URL: /cgi-bin/koha/circ/overdue.pl
Change sponsored?: Sponsored Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: add new sys pref FilterBeforeOverdueReport to the systempreferences table
add an index on the lib column to the authorisedvalues table

Description Chris Cormack 2010-05-21 00:57:21 UTC


---- Reported by rick@praxis.com.au 2008-12-16 23:00:32 ----

A request has been made to enhance the existing Overdues Report.

1. Create a new system preference “FilterBeforeOverdueReport” 
2. Option to filter *before* the overdue report runs, avoiding report slowness
3. Add searchable patron attributes to the list of overdue report filters 
4. Add searchable patron attributes to the sort fields on the overdue report 
5. Display searchable patron attributes on the overdue report 

This request is related to but not dependent upon the following bug:

2837  Descending sort doesn't descend on the overdues report
      plus other probs with report

The implementation of this request requires two database changes, which are attached to this ticket.



---- Additional Comments From rick@praxis.com.au 2008-12-16 23:06:55 ----

Created an attachment
add new sys pref FilterBeforeOverdueReport to  the systempreferences table

INSERT INTO systempreferences VALUES \
	('FilterBeforeOverdueReport',		0,	'',	'Do not run Overdue Report until filter selected', 'YesNo');




---- Additional Comments From rick@praxis.com.au 2008-12-16 23:08:19 ----

Created an attachment
add an index on the lib column to the authorisedvalues table

CREATE INDEX lib ON authorised_values (lib);



---- Additional Comments From gmcharlt@gmail.com 2009-05-27 21:59:35 ----

RFC is http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:filtering_and_sorting_the_overdue_report_using_patron_attributes



---- Additional Comments From gmcharlt@gmail.com 2009-05-29 00:27:48 ----

Patch pushed to HEAD.



---- Additional Comments From nengard@gmail.com 2009-06-01 14:55:10 ----

Should we change the warning on this page: cgi-bin/koha/circ/circulation-home.pl to note that you can solve this with the new system preference?



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 00:57 UTC  ---

This bug was previously known as _bug_ 2866 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2866
Imported an attachment (id=900)
Imported an attachment (id=901)

Actual time not defined. Setting to 0.0
The original submitter of attachment 900 [details] is unknown.
   Reassigning to the person who moved it here: chris@bigballofwax.co.nz.
The original submitter of attachment 901 [details] is unknown.
   Reassigning to the person who moved it here: chris@bigballofwax.co.nz.