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)
Created attachment 3720 [details] [review]
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?
Yep, I think it is ok to sign off.
Pushed, please test
When I click on 'Use Saved' I get the following 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.
Fixed, please retest