Unresolved Suggested Edits

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
            /*--  https://stackapps.com/review/suggested-edits/5465
                Note that this Id is NOT the suggested edit Id!
                Rather it is the review-task Id.
            */
            'site://review/suggested-edits/' + CAST (rt.Id AS NVARCHAR) + '|' + 'Edit ' +  CAST (rt.Id AS NVARCHAR)  AS [Edit Link]
            , se.CreationDate   AS [Created]
            , se.OwnerUserId    AS [User Link]
            , se.Comment
            , se.Title
            , se.Tags
            , se.Text
            , se.PostId         AS [Post Link]
FROM        SuggestedEdits      se
INNER JOIN  ReviewTasks         rt  ON se.Id = rt.SuggestedEditId
WHERE       se.ApprovalDate     IS NULL
AND         se.RejectionDate    IS NULL
ORDER BY    se.Id

Enter Parameters

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