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

<pre>
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
</pre>

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
--------------------------------------------------------------------------------
I agree that the current behaviour is not designed for inactive projects but it's clearly not a defect.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
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).
--------------------------------------------------------------------------------
This is still important, I have some projects with low activity and "Last activity" doesn't show events that happens 2 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.
--------------------------------------------------------------------------------
+1

Thanks for great patches
I don't want to repeat the blank history.

Note.

If the following patches have been applied, only two files need to be changed.
https://www.redmine.org/issues/23954#note-11

controllers/activities_controller.rb
app/views/activities/index.html.erb

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

relates,New,23954,Shows the date of the last activity on Projects administration.