Bug 2866 - Filtering and sorting the overdue report using patron attributes
Summary: Filtering and sorting the overdue report using patron attributes
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: PATCH-Sent (DO NOT USE) enhancement (vote)
Assignee: Galen Charlton
QA Contact:
URL: /cgi-bin/koha/circ/overdue.pl
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-16 11:00 UTC by Rick Welykochy
Modified: 2012-10-25 22:36 UTC (History)
1 user (show)

See Also:
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 (139 bytes, text/sql)
2008-12-16 23:06 UTC, Chris Cormack
Details
add an index on the lib column to the authorisedvalues table (47 bytes, text/sql)
2008-12-16 23:08 UTC, Chris Cormack
Details

Note You need to log in before you can comment on or make changes to this bug.
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.