0

Please login or register to vote for this query.

(click on this box to dismiss)

Finds edit suggestions made and approved after a question was closed to help find the potentially useless.

Q&A for SharePoint enthusiasts

-- (Potentially) useless edit suggestions on closed questions
-- Finds edit suggestions made and approved after a question was closed to help find the potentially useless.

SELECT
    se.PostId AS [Post Link],
    se.Comment,
    se.ApprovalDate AS [Edit Approval Date],
    p.ClosedDate AS [Question Closed Date]
FROM
    SuggestedEdits se
    JOIN Posts p
    ON se.PostId = p.Id
WHERE
    se.CreationDate > p.ClosedDate AND
    se.ApprovalDate IS NOT NULL
ORDER BY
    se.ApprovalDate DESC

fork query

created oct 7 11 Jeff Mercado