« first day (385 days earlier)      last day (1720 days later) » 

Feeds
Feeds
11:01 AM
1
Q: Query for no. of many questions I have answered which are closed later

Nog ShineIs there a query to know how many received answers before they are put on hold and I am the one who wrote the answer before the question is closed? If it looks confusing, let me explain. For example, you write an answer for a question. Later, the question gets closed as duplicate or too broad or...

support search data-explorer closed-questions
 
Martin
Martin
11:26 AM
2
A: Query for no. of many questions I have answered which are closed later

GlorfindelYes, there is now. I've got five answers by you on Meta Stack Exchange which qualify: The query looks at questions which are currently closed; if they have been reopened in the meantime, they will not appear in the results.

@Glorfindel I have tried to make a query which includes also questions which have been closed and later reopened - I am not sure whether it works as supposed: data.stackexchange.com/meta.stackexchange/revision/1092483/…
 
rene
rene
12:05 PM
@Martin that was what I had in mind as well. I guess that could go as an answer
 
Martin
Martin
12:24 PM
I have posted an answer. (I have added DISTINCT into the above query - to avoid having the same answer listed multiple times.)
 
Glorfindel
Glorfindel
1:00 PM
@Martin +1, that was my plan as well for after the run I just finished. Glad to see I don't need to open my laptop and I can head straight for the swimming pool instead.
 
Martin
Martin
Thanks for the response!
Still, if you notice some problems with the query I suggested, let me know.
 
 
7 hours later…
rene
rene
8:03 PM
@Glorfindel in training for a Marathon?
 

« first day (385 days earlier)      last day (1720 days later) »