Task 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 tasks)
Version: Main
Hardware: All All
: PATCH-Sent (DO NOT USE) enhancement
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:
GIT URL:
Change sponsored?: Sponsored
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


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 task.
Description Chris Cormack 2010-05-21 00:57:21 UTC


---- Reported by 64;praxis.com.au">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 64;praxis.com.au">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 64;praxis.com.au">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 64;gmail.com">gmcharlt@gmail.com 2009-05-27 21:59:35 ----

RFC is ﷒0﷓



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

Patch pushed to HEAD.



---- Additional Comments From 64;gmail.com">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 64;bigballofwax.co.nz">chris@bigballofwax.co.nz 2010-05-21 00:57 UTC  ---

This bug was previously known as _bug_ 2866 at ﷒1﷓
Imported an attachment (id=900)
Imported an attachment (id=901)

Actual time not defined. Setting to 0.0
The original submitter of ﷒2﷓ is unknown.
   Reassigning to the person who moved it here: 64;bigballofwax.co.nz">chris@bigballofwax.co.nz.
The original submitter of ﷒3﷓ is unknown.
   Reassigning to the person who moved it here: 64;bigballofwax.co.nz">chris@bigballofwax.co.nz.