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

Christian Fopke

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

Guilherme Nedel

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;