Is it possible to exclude questions I've already answered from the search criteria?

Question

Recently I asked if it were possible to find questions with just one answer and as a result we got an awesome range feature. That's great, but if you give a user a cookie...

Is there a way to restrict the search to questions where that one answer isn't mine? That would help. :-)

It's certainly possible to search for your own posts, but it's not possible to exclude your own posts as far as I can tell:

• -user:me searches for posts that don't have the string "user:me".
• user:1-67 doesn't search for posts from user #1 to user #67, but searches for posts from user #167. (And I'm not sure that will help anyway since I don't think it would be possible to simultaneously exclude 69-max(userID).)
• -Ericson searches for posts that don't include my last name, but since my last name is in the the metadata and not the searchable portion of posts: no joy.

And of course none of this will actually work to eliminate the questions that that I've answered already and want to ignore. In general, If I'm involved in a Q&A (or quan) the notification procedures do a good job of keeping me up-to-date with developments. But when I search, it's often to find questions I've not noticed before. So being able to eliminate questions I have already answered would be a generally useful feature for me.

Answer 1

Given that we now have all public sites (beta and graduated) in the Stack Exchange Data Explorer, it's possible to do searches like this via SQL:

with answered_by_me as (
  select q.Id PostId
  from Posts q
     join Posts a on q.Id = a.ParentId
  where q.Tags like '%##tags##%'
        and a.OwnerUserId = ##UserId##
)

select Id as [Post Link], Tags
from answered_by_me
     right outer join Posts on Id = PostId
where Tags like '%##tags##%'
      and PostId is null

So this query shows me all the luanumber questions I haven't answered. (Which turns out to be just 20 at the moment. I could totally do that.) In any case, the more complicated the search criteria, the more useful talking directly to the database will be. (Exception: full text searches of the body of posts will likely time out on sites like Stack Overflow with a lot of posts.)

Answer 2

What I'd like to see, is the option hasanswerby:user, where user can be me or any other user ID.

That way, we could include or exclude questions answered by ourselves or by any other user.