Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.
Sign up to join this community
I have some ideas for some "Answer your own question" questions on one of the beta sites but I was hoping to find some others to check the style being used for them, but I can't think of a way to locate the questions other than working out a query on Data Explorer.
Is there a shortcut search I can use to find a list of Q&A questions on a StackExchange site?
You can find the questions that are self-answered from SEDE with this query
select top 1000 q.id as [Post Link]
, q.owneruserid as [User Linkl]
, q.creationdate as [Asked on]
, a.creationdate as [Answered On]
from posts q
inner join posts a on a.id = q.AcceptedAnswerId
where q.posttypeid = 1 -- Q
and a.posttypeid = 2 -- A
and a.owneruserid = q.owneruserid
You basically join the posts table with itself on the id and acceptedanswerid and where the owneruserid of both are equal are self-answered questions.
Do notice that SEDE is only updated weekly.
Currently there is no way. But would be good if was.
