Feature #1422

Date selection for Activity Page

Added by Mateo Murphy almost 12 years ago. Updated 3 months ago.

Status:NewStart date:2008-06-10
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Activity view
Target version:-
Resolution:

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


Related issues

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

History

#1 Updated by Mischa The Evil almost 12 years ago

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

#2 Updated by Nanda P almost 11 years ago

+1

#3 Updated by Jens Goldhammer almost 11 years ago

+1

#4 Updated by Anonymous about 9 years ago

+1

#5 Updated by Terence Mill about 9 years ago

+1

#6 Updated by Eduardo Turiño over 8 years ago

+1

#7 Updated by Preethi Sriram about 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 over 6 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 over 6 years ago

+1. Very useful.

#10 Updated by Frei-Cedric Hackbarth - macio GmbH over 5 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 over 5 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 over 5 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 over 5 years ago

okay, thank you for your feedback.

#14 Updated by Fran Fabrizio over 4 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 over 3 years ago

+1

#16 Updated by JW Fuchs about 3 years ago

+1

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

#17 Updated by Thomas Thorne over 2 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 almost 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 over 1 year ago

  • Category changed from UI to Activity view

#20 Updated by Yuuki NARA over 1 year 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 5 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 3 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 3 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}"

Also available in: Atom PDF