Feature #1422

Date selection for Activity Page

Added by Mateo Murphy over 12 years ago. Updated 5 months ago.

Status:ClosedStart date:2008-06-10
Priority:NormalDue date:
Assignee:Go MAEDA% Done:

0%

Category:Activity view
Target version:4.2.0
Resolution:Fixed

Description

I occasionally find myself needing to check out the activity for a certain date, and the UI for the activity page doesn't provide an easy way to do that. I think it would be useful to have some dropdowns to be able to jump to a certain date or date range.

Any thoughts on this?

activitydaterange.patch Magnifier (3.09 KB) Preethi Sriram, 2012-04-06 19:43

activitydaterange-for-2.5.2.patch Magnifier - The feature patch for redmine V2.5.2 (4.84 KB) Frei-Cedric Hackbarth - macio GmbH, 2014-10-13 09:41

activitydaterange-for-2.6.0.patch Magnifier - The feature patch for redmine V2.6.0 (4.84 KB) Frei-Cedric Hackbarth - macio GmbH, 2014-11-13 10:07

selectable-from-date@2x.png (50 KB) Go MAEDA, 2019-12-19 04:07

feature-1422.patch Magnifier (1.42 KB) Mizuki ISHIKAWA, 2020-03-17 08:51

ScreenShot-feature-1422-patch.png (194 KB) Mizuki ISHIKAWA, 2020-03-17 08:54

Screenshot_2020-06-16.png (232 KB) Go MAEDA, 2020-06-16 14:44


Related issues

Duplicated by Redmine - Feature #3474: Make date range in module Activity selectable through user Closed 2009-06-10

Associated revisions

Revision 19828
Added by Go MAEDA 5 months ago

Date selection for Activity page (#1422).

Patch by Mizuki ISHIKAWA.

Revision 19829
Added by Go MAEDA 5 months ago

Update locales (#1422).

History

#1 Updated by Mischa The Evil over 12 years ago

+1, It would be quite handy to have from- / to-selectors for a custom timespan.

#2 Updated by Nanda P over 11 years ago

+1

#3 Updated by Jens Goldhammer over 11 years ago

+1

#4 Updated by Anonymous over 9 years ago

+1

#5 Updated by Terence Mill over 9 years ago

+1

#6 Updated by Eduardo Turiño almost 9 years ago

+1

#7 Updated by Preethi Sriram over 8 years ago

Attached is a patch for date range filter for activity feed. It defaults to initial setting and has apply link to set a date range to filter the feed.

#8 Updated by Daniel Küppers almost 7 years ago

If we add there a possibility to also filter by user, the activity page would be much more efficient. By now, i have setup a linkpage for me with the date and the user id's but thats not the way it should be.

#9 Updated by Dipan Mehta almost 7 years ago

+1. Very useful.

#10 Updated by Frei-Cedric Hackbarth - macio GmbH about 6 years ago

I used the patch “activitydaterange.patch” of Preethi Sriram, but the patch wasn´t compatible anymore. So I implemented the feature for the actual redmine version 2.5.2.
My Patch adds a datepicker for “from” and “to” in the activity tab. So it is possible to set the timespan of interest.

Is it possible to commit the feature to the trunk?

#11 Updated by Frei-Cedric Hackbarth - macio GmbH about 6 years ago

I updated my patch to redmine version 2.6.0. Is it possible to commit the feature to the trunk?

#12 Updated by Jean-Philippe Lang about 6 years ago

Being able to request a free date range for the activity is not really acceptable (requesting a few years of activity here would lead to a timeout or a really huge page).

The initial request was more about changing the UI to be able to select the date. That would be fine.

#13 Updated by Frei-Cedric Hackbarth - macio GmbH almost 6 years ago

okay, thank you for your feedback.

#14 Updated by Fran Fabrizio about 5 years ago

Jean-Philippe Lang wrote:

Being able to request a free date range for the activity is not really acceptable (requesting a few years of activity here would lead to a timeout or a really huge page).

This could be addressed by limiting the total number of records allowed to be returned, but I hope that the entire concept of having a date range selection for the activity feed isn't what you find unacceptable. It would be a useful feature and for lots of projects, years' worth of activity would not be a problem performance- or size-wise, so it seems too limiting to reject the idea on the basis that some projects would have trouble with a query spanning years.

After all, the issue query view allows me to query for all tickets for the past 10 years (which in our case returned several thousand tickets in a few seconds on a fairly underpowered VM that runs our instance), so the principle of multi-year queries is already in place elsewhere in Redmine.

The initial request was more about changing the UI to be able to select the date. That would be fine.

At the risk of being overly pedantic, the initial request did mention date ranges too.

Hopefully we can reconsider this feature and come up with a version that meets everyone concerns, because it seems too useful to dismiss entirely.

Thanks,
Fran

#15 Updated by Marco Descher almost 4 years ago

+1

#16 Updated by JW Fuchs over 3 years ago

+1

Date ranges like "last week", "last month" etc. would be very useful.

#17 Updated by Thomas Thorne about 3 years ago

A date range on the URL would be useful. Seeing the from=<start_date> parameter on the URL I tried to enter a to=<end_date> without success.

I can see there are concerns about people setting date ranges that are difficult to handle. I do not know how many records the specific user activity pages would return right now. If that was going to be too many could pagination be added to the user filtered activity view, as is done for the unfiltered view? Then if people wanted a larger number of records on a single page they could set some items_per_page value to a high number that would take a looooong time to server.

#18 Updated by Tom Lithgow over 2 years ago

Hello all, We have the need to customize the results in the activity too. By date/date range is very important, but also would it make sense to allow custom queries here too?
Specifically we would like to be able to see Date range + Project, and/or Date range + User.

Is the above possible in any way?

#19 Updated by Go MAEDA about 2 years ago

  • Category changed from UI to Activity view

#20 Updated by Yuuki NARA almost 2 years ago

+1

It is inconvenient that you can not easily find what you previously commented on.

You need to press the following Next and Previous link several hundred times.

http://www.redmine.org/activity?from=%year-month-date%&user_id=%user_id%

#21 Updated by Go MAEDA 11 months ago

I think adding an ability to set only "From" date would be an improvement.

  • Users will be able to set any from-date without tweaking the URL
  • It does not cause a problem JPL pointed out in #1422#note-12 (requesting a free date range will cause a timeout)
  • Since ActivitiesController already accepts params[:from], the change is small and easy to implement

#22 Updated by Mizuki ISHIKAWA 8 months ago

I have attached the patch.

This patch adds a date field to the sidebar.
If you enter the date as 2020/03/17 and press the [Apply] button, the activities for 30 days until 2020/03/17 will be displayed.
30 days is the value set in Setting(Setting.activity_days_default).

#23 Updated by Mizuki ISHIKAWA 8 months ago

Go MAEDA wrote:

I think adding an ability to set only "From" date would be an improvement.

The following processing is executed in the index action of activities_controller.
https://www.redmine.org/projects/redmine/repository/revisions/19580/entry/trunk/app/controllers/activities_controller.rb#L29

    if params[:from]
      begin; @date_to = params[:from].to_date + 1; rescue; end
    end

    @date_to ||= User.current.today + 1
    @date_from = @date_to - @days

The parameter name is from(params[:from]), but it is actually used to create @date_to.
Therefore, changed "30 days from {date}" to "30 days to {date}"

#24 Updated by Go MAEDA 5 months ago

Mizuki ISHIKAWA wrote:

I have attached the patch.

This patch adds a date field to the sidebar.
If you enter the date as 2020/03/17 and press the [Apply] button, the activities for 30 days until 2020/03/17 will be displayed.
30 days is the value set in Setting(Setting.activity_days_default).

Thank you, looks really nice. Setting the target version to 4.2.0.

Just for your information, Trac has a similar interface with your patch.

#25 Updated by Go MAEDA 5 months ago

  • Status changed from New to Closed
  • Assignee set to Go MAEDA
  • Resolution set to Fixed

Committed the patch attached in #1422#note-22 with slight modifications. Thank you for your contribution.

Also available in: Atom PDF