Feature #2531
closed
"Within period" query filters for date fields
0%
Description
Add new option "Within period" to date filter types (along with "Today", "This week", "Less than days ago" and ect). When user selected "Within period" there should be 2 date editors - "from" and "to". Let's treat both fields as optional so user can fill all possible combinations ("from+to", "from" only or "to" only).
Note, "from" and "to" should
- be inclusive
- ignore time difference in DB
- "from=01/12/2008" means "from=01/12/2008 00:00:00"
- "to=02/12/2008" means "to=02/12/2008 23:59:59"
Related issues
Updated by Artem Vasiliev over 15 years ago
I've just implemented it for http://github.com/artemv/redmine_tt fork, see commits:
http://github.com/artemv/redmine_tt/commit/ee3a1545fbf6b5a211c2947c0f68b8402a388f91
http://github.com/artemv/redmine_tt/commit/244408dbb277cb183ad48dfb8e7a52b5baa85d19
http://github.com/artemv/redmine_tt/commit/a2831f2a0a0f5948c5583980578cb6c29e9fd7e6
These are based on modified r1783.
These also make all time filters timezone-aware, i.e. if X.created_at = yesterday 00:00
or yesterday 23:59 in the same timezone
'1 days ago' filter should show issue X.
Currently redmine.org does have problems with this, e.g. 'updated at 0 days ago' shows issues updated at both today and yesterday if I'm in Alaska.
This accuracy requires switching to Rails timezones support, see
http://github.com/artemv/redmine_tt/commit/e4722216ff3893f032dc9a757715a161afb51339#diff-34,
http://github.com/artemv/redmine_tt/commit/e4722216ff3893f032dc9a757715a161afb51339#L0R24
and http://github.com/artemv/redmine_tt/blob/ad632ca3eb21b976ca606dc111f858678806d47e/lib/tasks/convert_database_times_to_utc.rake
Updated by Artem Vasiliev over 15 years ago
Artem Vasiliev wrote:
This accuracy requires switching to Rails timezones support, see
http://github.com/artemv/redmine_tt/commit/e4722216ff3893f032dc9a757715a161afb51339#diff-34,
http://github.com/artemv/redmine_tt/commit/e4722216ff3893f032dc9a757715a161afb51339#L0R24
and http://github.com/artemv/redmine_tt/blob/ad632ca3eb21b976ca606dc111f858678806d47e/lib/tasks/convert_database_times_to_utc.rake
+ http://github.com/artemv/redmine_tt/commit/e4722216ff3893f032dc9a757715a161afb51339#L5L97
Updated by Artem Vasiliev over 15 years ago
That Rails timezone support is summarized in #1705 actually
Updated by Artem Vasiliev about 15 years ago
I've just implemented it for http://github.com/artemv/redmine_tt fork, see commits:
Another tweak to it: http://github.com/artemv/redmine_tt/commit/a8f2f4ced8d66dc0def3baf863f785d85d100fdb
Updated by Curtis Stewart about 15 years ago
+1
I just had two different requests for filtering issues within a data range. We have made due with exporting to csv and then removing the extra items, but that is not as convenient. I would like to see this patch, or something similar, incorporated into the main releases.
Updated by Etienne Massip almost 13 years ago
- Category set to Issues
I think this has been committed in trunk for 1.3.0.
Updated by Nayuta Taga over 12 years ago
+1
Etienne Massip wrote:
I think this has been committed in trunk for 1.3.0.
Please tell me the committed revision.
I want to apply it to my local Redmine.
Updated by Etienne Massip over 12 years ago
- Status changed from New to Closed
- Resolution set to Duplicate