How to see a statistic: pages updated for one space category

Hi, we have one space per project (category "project"). Home page is a data sheet with important informations, status, involved persons ...

Do we have a possibility seeing all projects in a list like "not updated since" or "last update"..?

By using category - maybe and status ?

Kind regards, Christian

1 answer

Hello Christian, I believe this can be helpful and a good start:

SELECT spaces.spacename, MAX(content.lastmoddate)
FROM content, spaces
WHERE content.spaceid = spaces.spaceid
GROUP BY spaces.spacename;

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

It isn´t a macro, but brilliant. Good idea, using SQL in this case - thank you ! Best regards, Chris

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.