I was wondering if it is also possible to search for questions which are unanswered AND also lack any comments? I could not find it here or using Google.
-
Is there a reason to want to do this? The network deliberately view comments as 'expendable' so they are not generally part of searching ...– Joseph Wright ModCommented Oct 2, 2016 at 11:13
-
1@JosephWright If you want to find unanswered questions, which are not resolved in the comments.– RoaldCommented Oct 2, 2016 at 11:15
-
Not all questions that have comments but no answers are automatically answered by the comments. Some are, true. You can browse all unanswered questions, have a look at the comments (if any) and ping the user who gave the answer or even flag as duplicate or unclear. It is a bit more work, but it is much more helpful in the long run. My opinion at least.– Johannes_BCommented Oct 5, 2016 at 18:01
-
@Johannes_B That is true. Although I find that when I look through those questions, I come across quite a few which were answered in the comments and I did not want to make community wiki answers for them all.– RoaldCommented Oct 5, 2016 at 20:45
-
2@Roald Pinging the user who answered is definitely not writing a CW answer.– cfrCommented Oct 6, 2016 at 3:29
Add a comment
|
1 Answer
You can only link the two databases containing posts and comments using the SEDE. The following query lists questions on the main site, sorted by their last activity date (oldest to newest) with these attributes:
No comment
No answer
Not closed
Positive score
select top 1000
p.id as [Post Link],
p.lastactivitydate as [Last Active]
from posts p
left outer join comments c on c.postid = p.id
where p.posttypeid = 1 -- Questions
and c.id is null
and answercount = 0
and p.score > 0
and closeddate is null
order by lastactivitydate
