Recent mod actions on questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Tridion

Q&A for Tridion developers and administrators

--actions that can only be done by moderators
SELECT TOP(##num?100##)
    ph.CreationDate,
  ph.PostHistoryTypeId,
  ph.UserId AS [User Link],
  ph.UserDisplayName,
  p.Id AS [Post Link],
  concat('site://posts/',
          p.Id,
          '/revisions'
          ) [Revisions Link],
  CASE ph.PostHistoryTypeId
   WHEN 14 THEN 'Locked'
   WHEN 15 THEN 'Unlocked'
   WHEN 16 THEN 'CW'
   WHEN 37 THEN 'Merged'
   WHEN 38 THEN 'Merged'
   WHEN 53 THEN 'HNQ'
  END         
FROM PostHistory ph INNER JOIN Posts p
  ON ph.PostId=p.Id
  AND ph.PostHistoryTypeId IN (14,15,16,37,38,53)
  AND p.PostTypeId=1
ORDER BY ph.CreationDate DESC

--14 = Post Locked - post locked by moderator
--15 = Post Unlocked - post unlocked by moderator
--16 = Community Owned - post now community owned
--QUESTION can only be made CW by a moderator (so I look only at question; PostTypeId=1)
--37 = Post merge source
--38 = Post merge destination
--53 = removed from HNQ

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results