[Bug 6033] New: Add Filters to SQL Saved Reports
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Bug #: 6033 Summary: Add Filters to SQL Saved Reports Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_4 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Reports AssignedTo: gmcharlt@gmail.com ReportedBy: shelley@catalyst.net.nz QAContact: koha-bugs@lists.koha-community.org We'd like to add filters to the SQL reports list; long lists of reports are very difficult to navigate. The filters should be on date, author and keyword. Keyword would match against report name, notes, and the actual SQL itself. The default sort for the reports should alphabetical by report name, ascending. Additionally, there should be a way to go back to a particular filter and page number of results after viewing the SQL, or running the report. Having the same pagination code that is now present on Item Types and Authorized Values would be nice... but making that information 'memorable' to the system would likely add needless complication. If going Back can remember the search filters, that should be sufficient (librarians can just filter better if they need more precision) -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Shelley <shelley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Change sponsored?|--- |Sponsored AssignedTo|gmcharlt@gmail.com |chris@bigballofwax.co.nz -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Srdjan Jankovic <srdjan@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED AssignedTo|chris@bigballofwax.co.nz |srdjan@catalyst.net.nz --- Comment #1 from Srdjan Jankovic <srdjan@catalyst.net.nz> 2011-04-06 03:40:43 UTC --- Created attachment 3720 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=3720 patch -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 |PATCH-Sent CC| |chris@bigballofwax.co.nz Version|rel_3_4 |rel_3_6 Patch Status|--- |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Frederic Durand <frederic.durand@univ-lyon2.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |frederic.durand@univ-lyon2. | |fr --- Comment #2 from Frederic Durand <frederic.durand@univ-lyon2.fr> 2011-04-06 14:58:57 UTC --- Filters working good. Default sort too. No particular way to get back to your filter, but if you re using going back or clicking on report's link, it keeps your filter in mind. Pagination is the same as Authorized values. Just missing the memorisation of page's number when going back. But seems enough to signed it off as well no? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 --- Comment #3 from Chris Cormack <chris@bigballofwax.co.nz> 2011-04-06 17:00:16 UTC --- Yep, I think it is ok to sign off. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Frederic Durand <frederic.durand@univ-lyon2.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Needs Signoff |Signed Off -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Signed Off |Patch Pushed --- Comment #4 from Chris Cormack <chris@bigballofwax.co.nz> 2011-04-28 01:34:54 UTC --- Pushed, please test -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nengard@gmail.com --- Comment #5 from Nicole C. Engard <nengard@gmail.com> 2011-04-28 12:29:36 UTC --- When I click on 'Use Saved' I get the following error: Software error: Template process failed: file error - parse error - /home/nengard/kohaclone/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt line 140: unexpected token (") [% filter_author" %] at /home/nengard/kohaclone/C4/Templates.pm line 119. For help, please send mail to the webmaster (webmaster@debian), giving this error message and the time and date of the error. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 --- Comment #6 from Chris Cormack <chris@bigballofwax.co.nz> 2011-04-28 21:41:48 UTC --- Fixed, please retest -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6033 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org