Last activity time window.
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.
#1 Updated by Zarooba Rozruba almost 10 years ago
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.
#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).
#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.