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?

  • I hope such questions is on topic here, I’m sorry if it’s not :) – user569408 Jan 3 at 17:05
  • 2
    SEDE questions are indeed on-topic. The SEDE tour even points you directly here (to MSE) for any questions about it. – Rubiksmoose Jan 3 at 17:10

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:

enter image description here

| improve this answer | |
  • 1
    I would have expected that join with users to be on the owneruserid of the answers. The OP probably knows when he was last active – rene Jan 3 at 17:22
  • 2
    @rene Jdrupal has accepted all but 1 of his answered questions. It's more logical that he's looking for his own unaccepted answers to questions by recently active users. – Glorfindel Jan 3 at 17:54
  • 1
    @Glorfindel You’re correct. That’s what I want :) – user569408 Jan 3 at 18:34
  • How can I filter the results to only show answers where score is > 0, thanks :) – user569408 Jan 3 at 22:44
  • @Jdrupal that's not too difficult, just add AND a.Score > 0 to the WHERE clause. You can fork the query to do so. FYI, you might be interested in the SEDE tutorial. – Glorfindel Jan 3 at 23:11

You must log in to answer this question.