4

I saw View my questions with unaccepted answers but my question is not only about my questions. Instead: I would like to get a list of all these questions (on a specific site) which

  • I answered to
  • which do not have an accepted answer.

Beyond that: how to create that list for questions where my answer is the only one?

Improve this question
0

1 Answer 1

Reset to default
7

That's not too hard; here is one for part 1, and here is part 2.

For reference, here is the second query (the first one is identical, but leaves out the q.AnswerCount = 1 condition):

SELECT q.Id AS [Post Link], a.CreationDate
  FROM Posts AS q
  INNER JOIN Posts AS a ON a.ParentId = q.Id
  WHERE a.OwnerUserId = ##UserId##
    AND q.AnswerCount = 1
    AND q.AcceptedAnswerId IS NULL
Improve this answer
1
  • Excellent! Thank you sir.
    – GhostCat
    Commented Aug 3, 2017 at 7:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .