5

Please login or register to vote for this query.

(click on this box to dismiss)

Shows all of a user name's suggested edits.

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

-- My rejected edits
-- Shows all my suggested edits that were rejected by the reviewers.
-- Works for all StackExchange sites

select U.DisplayName, e.OwnerUserID, 'site://suggested-edits/'+CONVERT(VARCHAR,e.id)+'|Suggested Edit #'+CONVERT(VARCHAR,e.id) [Suggested Edit Link], 
        PostId as [Post Link], e.Comment, e.CreationDate, e.RejectionDate
 from SuggestedEdits as e join Users as U on e.OwnerUserID = U.ID 
WHERE U.DisplayName='##DisplayName##' and e.RejectionDate is not null
 order by e.RejectionDate desc

view current version

edited nov 3 17 anonymous

created aug 31 11 Idolon