I want to get a list of my own un-accepted answers, where the OP have been active during the last week.
How can I write such a query on SEDE?
Is it even possible to query a user's activity on a site?
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
The main problem with SEDE is that data is only updated once a week, on Sunday morning. So 'active during the last week' is going to be tough (depending on when you run the query). That said, this SEDE query is close to what you're looking for. You'll need your user ID and a date before last Sunday, e.g. 2019-12-01: