I want to get all of my upvoted answers where the question doesn’t have a specific tag.
What query can I write to get that data from SEDE?
For example, I want to get all my upvoted answers to posts that have not been tagged feature-request.
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
You don't need SEDE for this, the regular search is perfectly capable of this.
user:me is:a score:1 -[feature-request]
For me, that search query produces the following results:
Of course, it can be done in SEDE and it's a nice exercise. Here are some pointers:
Poststable with itself, the
ParentIdof the answer is the
Idof the question
OwnerUserIdof the answer. You can make this a parameter, so other users can use your query too, and I've written a userscript to fill it automatically.
Tagsof the question, i.e.
NOT LIKE '%<feature-request>%'. Bonus points if you make that a parameter too. (Joining with
Tagsis possible as well.)
Scoreof the answer. If you mean posts which received at least one upvote (and an arbitrary number of downvotes), you'd have to join with the
Votestable and filter for votes with
VoteTypeIdequal to 2. Then you'd need a
GROUP BY) since you don't want an answer that is upvoted n times to appear n times in the results.