Unresolved/Incomplete Review Tasks

1

Please login or register to vote for this query.

(click on this box to dismiss)

Of course, if it's less than a week or 2 old, it probably got resolved by now (SEDE snapshot lag).

Stack Overflow

Q&A for professional and enthusiast programmers

-- ReviewType: Enter type (1 thru 11) or 0 for all types
SELECT      TOP 5000  -- Limit to 5K so SEDE will put live sort controls on table.
            r.PostId                                    AS [Post Link]
            , t.Name                                    AS [Review Type]
            , 'site://review/' + (
                CASE    WHEN r.ReviewTaskTypeId =  1  THEN 'suggested-edits/'
                        WHEN r.ReviewTaskTypeId =  2  THEN 'close/'
                        WHEN r.ReviewTaskTypeId =  3  THEN 'low-quality-posts/'
                        WHEN r.ReviewTaskTypeId =  4  THEN 'first-posts/'
                        WHEN r.ReviewTaskTypeId =  5  THEN 'late-answers/'
                        WHEN r.ReviewTaskTypeId =  6  THEN 'reopen/'
                        /*-- No records of these next 3 types exist in SEDE, active or otherwise.
                        WHEN r.ReviewTaskTypeId =  7  THEN 'community-evaluation/'
                        WHEN r.ReviewTaskTypeId =  8  THEN 'link-validation/'
                        WHEN r.ReviewTaskTypeId =  9  THEN 'flagged-posts/'
                        */
                        WHEN r.ReviewTaskTypeId = 10  THEN 'triage/'
                        WHEN r.ReviewTaskTypeId = 11  THEN 'helper/'
                END
            ) + CAST (r.Id AS NVARCHAR) + '|review ' + CAST(r.Id AS NVARCHAR)    AS [Review link]
            , r.CreationDate
            --, r.DeletionDate  -- This is always null for active tasks
            --, r.SuggestedEditId  -- Not really helpful here
            --, r.CompletedByReviewTaskId  -- This is always null for active tasks
FROM        ReviewTasks r
INNER JOIN  ReviewTaskTypes t                           ON t.Id = r.ReviewTaskTypeId
WHERE       r.ReviewTaskStateId = 1  -- Active
AND         (##ReviewType:INT?0## = 0  OR  r.ReviewTaskTypeId = ##ReviewType:INT?0##)
ORDER BY    r.CreationDate
            , t.Name

Enter Parameters

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