Recent reviews of the given types (including review result and ClosedDate)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Earth Science

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT TOP ##numberOfHits:int?100## 
  rt.PostId AS [Post Link], 
  rt.CreationDate,
  rt.DeletionDate,
  ReviewTaskTypeId,
  'site://review/'
   +CASE ReviewTaskTypeId
    WHEN 1 THEN 'suggested-edits'
    WHEN 2 THEN 'close'
    WHEN 3 THEN 'low-quality-posts'
    WHEN 4 THEN 'first-posts'
    WHEN 5 THEN 'late-answers'
    WHEN 6 THEN 'reopen'
    WHEN 12 THEN 'first-questions'
    WHEN 13 THEN 'first-answers'
  END+'/' + CAST(rt.Id AS NVARCHAR) + '|Review task',
  CASE ReviewTaskStateId 
    WHEN 1 THEN 'Active'
    WHEN 2 THEN 'Completed'
    WHEN 3 THEN 'Invalidated'
  END,   
  CASE ReviewTaskTypeId
    WHEN 1 THEN 'Suggested Edit'
    WHEN 2 THEN 'Close Votes'
    WHEN 3 THEN 'Low Quality Posts'
    WHEN 4 THEN 'First Post'
    WHEN 5 THEN 'Late Answer'
    WHEN 6 THEN 'Reopen Vote'
    WHEN 12 THEN 'First Questions'
    WHEN 13 THEN 'First Answers'
  END,
  CASE rtr.ReviewTaskResultTypeId 
    WHEN 1 THEN 'Skip'
    WHEN 2 THEN 'Approve (suggested edits)'
    WHEN 3 THEN 'Reject (suggested edits)'
    WHEN 4 THEN 'Delete (low quality)'
    WHEN 5 THEN 'Edit (first posts, late answers, low quality)'
    WHEN 6 THEN 'Close (close, low quality)'
    WHEN 7 THEN 'Looks OK (low quality)'
    WHEN 8 THEN 'Do Not Close (close)'
    WHEN 9 THEN 'Recommend Deletion (low quality answer)'
    WHEN 10 THEN 'Recommend Close (low quality question)'
    WHEN 11 THEN 'Other Action (first posts)'
    WHEN 12 THEN 'Reopen (reopen)'
    WHEN 13 THEN 'Leave Closed (reopen)'
    WHEN 14 THEN 'Edit and Reopen (reopen)'
    WHEN 15 THEN 'Excellent (community evaluation)'
    WHEN 16 THEN 'Satisfactory (community evaluation)'
    WHEN 17 THEN 'Needs Improvement (community evaluation)'
    WHEN 18 THEN 'No Action Needed (first posts, late answers)'
  END,
  rtr.ReviewTaskResultTypeId,
  p.ClosedDate
--  p.DeletionDate
  FROM ReviewTasks rt RIGHT OUTER JOIN ReviewTaskResults rtr ON rtr.Id=rt.CompletedByReviewTaskId
  INNER JOIN PostsWithDeleted p ON p.Id=rt.PostId
  WHERE ReviewTaskTypeId IN (##types?1,2,12,13##)
  ORDER BY rt.CreationDate DESC

--ReviewTaskTypeId (listed in ReviewTaskTypes)
--1 = Suggested Edit
--2 = Close Votes
--3 = Low Quality Posts
--4 = First Post
--5 = Late Answer
--6 = Reopen Vote
--7 = Community Evaluation
--8 = Link Validation
--9 = Flagged Posts
--10 = Triage
--11 = Helper

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results