Post History by Review task

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

SELECT rt.ReviewTaskTypeId AS [rt TypeId], *

FROM PostHistory h
RIGHT OUTER JOIN ReviewTasks rt ON rt.PostId = h.Id
RIGHT OUTER JOIN ReviewTaskResults rtr ON rtr.Id = rt.CompletedByReviewTaskId

--RIGHT JOIN ReviewTaskResults rtr ON rtr.Id = rt.CompletedByReviewTaskId


WHERE rt.ReviewTaskTypeId IN (##types?4,12##)  
  AND (rt.CreationDate >= '##startDate?2005-01-01##') 
  AND (rt.CreationDate <= '##endDate?2030-12-31##')
  
ORDER BY h.Id DESC

Enter Parameters

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