Yet another report showing the latest 10 items on your system. This however take the startDate and endDate specified into account thus only showing active content. SQL report:
SELECT
CONCAT('/index.pl/',page.urlizedtitle),
wobject.title, concat(s1.fieldData, " ", s2.fieldData),
from_unixtime(wobject.lastedited, '%d-%m-%y')
FROM page, userProfileData as s1, wobject
INNER Join userProfileData AS s2 on (s1.userId = s2.userId )WHERE
page.pageid = wobject.pageid and
(s1.fieldName = "firstName" and editedBy = s1.userId) and s2.fieldName = "lastName" and
unix_timestamp() > wobject.startDate
AND
unix_timestamp() < wobject.endDate
ORDER BY wobject.lastedited DESC LIMIT 10
Report template:
see attached file!