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!

Comments

scotru: "
I tried pasting this SQL report in, but I'm only getting the latest 10 edits by a particular user.  Any ideas?

Thanks!
"

aaronp: "
This only selects pages that are not in the trash and are viewable by Visitor.

SELECT
 page.urlizedTitle, page.title,
 wobject.title, CONCAT(s1.fieldData, " ", s2.fieldData),
 FROM_UNIXTIME((wobject.lastedited + 18000), '%W, %b %D, %l:%s%p')

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
 AND (wobject.groupIdView = 1 OR wobject.groupIdView = 7)
 AND page.title!="Trash"

ORDER BY
 wobject.lastedited DESC

LIMIT"