Query for use by Open Vino support team.\n
Capped at 100 result to avoid too many data pull.\n
Results beyond six month are not included as they are considered abandoned.\n
Result are stored with \n
Added link to question using id.
Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
declare @d2 datetime
select @d2 =GETDATE()
SELECT TOP 100
Id as [Post Link],
--DateDiff(day,DATEADD(day, -5, GETDATE()),LastActivityDate) as SLA5day,
datediff(dd, LastActivityDate, @d2) - (datediff(wk, LastActivityDate, @d2) * 2) -
case when datepart(dw, LastActivityDate) = 1 then 1 else 0 end +
case when datepart(dw, @d2) = 1 then 1 else 0 end
Tags like '%<openvino>%'
AND AnswerCount = 0
AND CommentCount = 0
AND LastActivityDate > '2020-06-01'
ORDER by AnswerCount,CommentCount,LastActivityDate