List a user's rejected suggested edits

0

Please login or register to vote for this query.

(click on this box to dismiss)

List all the rejected suggested edits proposed by a given user.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  'site://suggested-edits/' + Cast(s.Id AS VarChar(20)) + '|' + CASE Len(LTrim(s.Comment)) WHEN 0 THEN '[none]' ELSE s.Comment END AS [Suggested edit],
  s.PostId AS [Post Link],
  s.CreationDate AS [Creation date],
  s.RejectionDate AS [Rejection date]
FROM SuggestedEdits s
WHERE s.OwnerUserId = ##UserId##
  AND s.RejectionDate IS NOT NULL
ORDER BY s.RejectionDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results