Accepted answers after closing a question

0

Please login or register to vote for this query.

(click on this box to dismiss)

Tridion

Q&A for Tridion developers and administrators

SELECT q.Id AS [Post Link],
  q.ClosedDate AS 'Closed on',
  v.CreationDate AS 'Accepted on'
  FROM Posts AS q
  INNER JOIN Posts AS a
    ON q.Id = a.ParentId
  INNER JOIN Votes AS v
    ON a.Id = v.PostId
  WHERE v.VoteTypeId = 1 -- Accept
    AND v.CreationDate > q.ClosedDate
  ORDER BY q.CreationDate DESC

Enter Parameters

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