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– Joseph Wright Mod2016-10-02 11:13:36 +00:00Commented Oct 2, 2016 at 11:13
- 1@JosephWright If you want to find unanswered questions, which are not resolved in the comments.Roald– Roald2016-10-02 11:15:24 +00:00Commented 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_B– Johannes_B2016-10-05 18:01:53 +00:00Commented 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.Roald– Roald2016-10-05 20:45:54 +00:00Commented Oct 5, 2016 at 20:45
- 2@Roald Pinging the user who answered is definitely not writing a CW answer.cfr– cfr2016-10-06 03:29:33 +00:00Commented 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 