https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21200 --- Comment #1 from paxed <pasi.kallinen@joensuu.fi> --- Created attachment 77643 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=77643&action=edit Bug 21200: Allow default values for saved SQL report "date" parameters Let the saved SQL report define default date values, relative to the time the report is being run, for any "date" fields. Often such date fields require entering a date eg. 6 months past or similar, and having the default value in would make it much less likely for the user to choose the wrong date. The default value is put after the "date" text, separated by a pipe. Format for the default date value is either "now", or "<value> <unit>", where value is a positive or negative integer value, and unit is one of "hour", "day", "week", "month", "year". Not putting in the default value would behave the same as before, leaving the date input field empty. For example: SELECT count(*) FROM items WHERE DATE(dateaccessioned) BETWEEN <<Start|date|-6 month>> AND <<End|date|now>> Would default to the last 6 months. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21200 paxed <pasi.kallinen@joensuu.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA --- Comment #2 from paxed <pasi.kallinen@joensuu.fi> --- Failing this due to tests, and because bug 21215 will make coding this easier. -- You are receiving this mail because: You are watching all bug changes.