List votes on a user's rejected suggested edits

0

Please login or register to vote for this query.

(click on this box to dismiss)

Show all the approval and rejection votes on the rejected suggested edits that were 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],
  CASE v.VoteTypeId WHEN 2 THEN 'Approved'
                    WHEN 3 THEN IIF(v.UserId = -1, 'Rejected by Community', 'Rejected')
                    ELSE '?' END AS [Type]
FROM SuggestedEdits s, SuggestedEditVotes v
WHERE v.SuggestedEditId = s.Id
  AND s.OwnerUserId = ##UserId##
  AND s.RejectionDate IS NOT NULL
ORDER BY v.CreationDate DESC

Enter Parameters

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