Feature #3099

Last activity time window.

Added by Adam Kubica almost 10 years ago. Updated 12 months ago.

Status:NewStart date:2009-04-02
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:UI
Target version:-
Resolution:

Description

Time window of last activity is between now and some interval to the past.

When project has no activity in that window, there is nothing to display - it's wrong.

Beginning of activity window shouldn't be now but the last activity of the project.

activity_always-r3.3.patch Magnifier - For Redmine <= 3.3 (7.19 KB) Frederico Camara, 2018-03-09 22:15

activity_always-r3.4.patch Magnifier - For Redmine 3.4 (7.38 KB) Frederico Camara, 2018-03-09 22:15

History

#1 Updated by Zarooba Rozruba almost 10 years ago

1+

I have some projects that are still used, but have not been updated for over a year.
The activity window should load last xx items than between specific dates.

In typical SQL this could be built with

select * from
(
    select date, type, url, subject, short_description, author
    from issues
    where projectid=[xyz] and date < [startdate]
    order by date desc
    limit 100
  union 
    select date, type, url, subject, short_description, author
    from changesets
    where projectid=[xyz] and date < [startdate]
    order by date desc
    limit 100
) 
order by date desc
limit 100

This query will read 100 last items from two activity types : issues and changesets.
Then, it will merge them, resort them, and display 100 of those.

It is somewhat wastefull (in theory, as each subquery reads more than it needs to), but with semi dead projects this is best visual (as opposed to having user keep pressing previous months just to see something, or anything).

Please forgive me for lack proper table/column names, am away from my redmine installation.

Kind regards

#2 Updated by Jean-Philippe Lang almost 10 years ago

I agree that the current behaviour is not designed for inactive projects but it's clearly not a defect.

#3 Updated by Jean-Philippe Lang almost 10 years ago

  • Tracker changed from Defect to Feature

#4 Updated by Adam Kubica almost 10 years ago

Jean-Philippe Lang wrote:

I agree that the current behaviour is not designed for inactive projects but it's clearly not a defect.

Not at all "inactive", some projects has low activity but aren't inactive, in this case it's a defect (people are desoriented).

#5 Updated by Adam Kubica over 8 years ago

This is still important, I have some projects with low activity and "Last activity" doesn't show events that happens 2 months ago.

#6 Updated by Frederico Camara 12 months ago

Wow, 9 years!

I made a related Patch #23954 which shows the last activity per project in the admin > project page. I had an idea how to always show something in the activity windows. Patch attached.

With this, the activities windows don't exactly page anymore, because periods of inactivity are repeated between pages. They show a 30 days (default configuration) period of activity and expand the start and end times through adjoining 30 day (default configuration) periods of inactivity. Also, it hides the previous/next buttons if there is no activity before/after.

Also available in: Atom PDF