Review results with links to the review page

0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the full ReviewTaskResults table, with a link to the corresponding review page on the site. Note that the site displays the user associated with each review task result, but the table does not.

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT TOP 50
  'site://review/'+(
    CASE
    WHEN ReviewTasks.ReviewTaskTypeId = 1 THEN 'suggested-edits'
    WHEN ReviewTasks.ReviewTaskTypeId = 2 THEN 'close'
    WHEN ReviewTasks.ReviewTaskTypeId = 3 THEN 'low-quality-posts'
    WHEN ReviewTasks.ReviewTaskTypeId = 4 THEN 'first-posts'
    WHEN ReviewTasks.ReviewTaskTypeId = 5 THEN 'late-answers'
    WHEN ReviewTasks.ReviewTaskTypeId = 6 THEN 'reopen' 
    -- 7, 10, 11 left for the reader to implement
    ELSE 'null'
    END ) + '/'
    + CAST(ReviewTaskResults.ReviewTaskId AS varchar)+'|'
    + CAST(ReviewTaskResults.ReviewTaskId AS varchar) AS 'Review Link',
  
  ReviewTaskResults.*
FROM ReviewTaskResults
JOIN ReviewTasks
  ON ReviewTaskResults.ReviewTaskId = ReviewTasks.Id
JOIN ReviewTaskTypes
  ON ReviewTaskTypes.Id = ReviewTasks.ReviewTaskTypeId
ORDER BY ReviewTaskResults.CreationDate DESC

Enter Parameters

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