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
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
Still have a question?
Get fast answers from people who know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.