Oldest 500 pending review tasks

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace

Q&A for members of the workforce navigating the professional setting

select top 500 'site://review-task/' + cast(t.Id as varchar) + '|' + q.Title as [Review Link], t.CreationDate
from ReviewTasks t
join Posts p on p.Id=t.PostId
join Posts q on q.Id=isnull(p.ParentId,p.Id)
where ReviewTaskStateId=1
and ReviewTaskTypeId in (1,2,3,4,5,6)
order by t.CreationDate asc

Enter Parameters

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