[openvino] unanswered by last activity

1

Please login or register to vote for this query.

(click on this box to dismiss)

Query for use by Open Vino support team.\n Capped at 100 result to avoid too many data pull.\n \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.

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

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 
      -6
      as SLATest,
AnswerCount,CommentCount

FROM POSTS

WHERE 
Tags like '%<openvino>%' 
AND AnswerCount = 0 
AND CommentCount = 0
AND LastActivityDate > '2020-06-01'

ORDER by AnswerCount,CommentCount,LastActivityDate

Enter Parameters

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