I have been asking more than a few questions here. I have never – that I know of – marked any of them as "answered". How can I bring up a screen of questions I have asked so I can mark them – individually – as answered as appropriate?
-
This lists all your questions and indicates if they have answers or not.– RamhoundCommented Jul 23, 2015 at 12:32
-
You have 10 accepted answers, by the way. Not sure how you could be unaware of that. Wouldn't doing the same thing 10 times give you at least a vague memory of having done it before?– allquixoticCommented Jul 25, 2015 at 12:01
-
I don't hang out on SuperUser and have never read the manual/instructions: as the kids so annoyingly say -- "my bad". I come in, ask my question and leave. Wait: it looks like Sathya has answered me,c, completely ...– greenberCommented Jul 26, 2015 at 10:09
2 Answers
Whilst this is overkill since you currently only have 38 questions some of which are closed, it is possible to query StackExchange sites for this kind of information using the Stack Exchange Data Explorer.
The following query will show questions with answers but none that are marked as 'accepted':
select q.Title, 'http://superuser.com/questions/' + cast(q.ID as varchar) as [Link]
from Posts q
where q.PostTypeId = 1 and q.OwnerUserId = 73534 and q.AcceptedAnswerId is null and ClosedDate is null and AnswerCount > 0
order by CreationDate desc
Query results can be found here.
Note that it seems to take a little while for the results to be synchronised with the live data.
-
2
-
+1 for the approach, most simple and straightforward way to do it. I didn't know superuser has db until I read this answer, this is much more powerful than only searching answer which is un-answered, it can slot any status of the question/user/answer.– BiloCommented Jul 26, 2015 at 11:00
An easier solution is to make use of user:me hasaccepted:no
search operator. This will give you all questions that you have not accepted.
Check the Search page and click on "Advanced Search Tips" for more such tips