find the reviews for a post

3

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackoverflow.com/questions/265648/is-there-a-way-to-find-a-specific-post-in-the-review-queue

Stack Overflow

Q&A for programmers

-- postid: id of the post "id found when you share an anwer or the link in the url"
select r.id
     , r.postid as [Post Link]
     , r.creationdate
     , r.deletiondate
     , rt.Name as [Type] 
     , rts.name as [State]
     , rtrt.name as [Result]
     , rtr.creationdate
     , re.name as [Reject reason]
     , rtr.comment
from reviewtasks r
left outer join reviewtasktypes rt on rt.id = r.ReviewTaskTypeId
left outer join ReviewTaskStates rts on rts.id = r.reviewtaskstateid
left outer join ReviewTaskResults rtr on rtr.reviewtaskid = r.id
left outer join ReviewTaskResultTypes rtrt on rtrt.id = rtr.ReviewTaskResultTypeId
left outer join ReviewRejectionReasons re on re.id = rtr.RejectionReasonid
where r.postid = ##postid##

Enter Parameters

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