---- 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.