Feature #2531

"Within period" query filters for date fields

Added by Artem Vasiliev almost 9 years ago. Updated almost 6 years ago.

Status:ClosedStart date:2009-01-19
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues
Target version:-
Resolution:Duplicate

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

Related to Redmine - Patch #1705: Use Rails timezones support New 2008-07-29
Duplicated by Redmine - Feature #6954: Filter from date to date Closed 2010-11-22

History

#1 Updated by Artem Vasiliev almost 9 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

#3 Updated by Artem Vasiliev almost 9 years ago

That Rails timezone support is summarized in #1705 actually

#5 Updated by Curtis Stewart over 8 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.

#6 Updated by Etienne Massip over 6 years ago

  • Category set to Issues

I think this has been committed in trunk for 1.3.0.

#7 Updated by Nayuta Taga almost 6 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.

#8 Updated by Etienne Massip almost 6 years ago

gana ware wrote:

Please tell me the committed revision.
I want to apply it to my local Redmine.

You should try to merge r6213, r6216, r6217, r6226, r6227, r6228, r6229, r6256, r6258, r6264 and r6265.

#9 Updated by Etienne Massip almost 6 years ago

  • Status changed from New to Closed
  • Resolution set to Duplicate

Closed as duplicated by #6954 which has been committed for 1.3.0.

#10 Updated by Nayuta Taga almost 6 years ago

Etienne Massip wrote:

gana ware wrote:

Please tell me the committed revision.
I want to apply it to my local Redmine.

You should try to merge r6213, r6216, r6217, r6226, r6227, r6228, r6229, r6256, r6258, r6264 and r6265.

Thanks a lot!

Also available in: Atom PDF