I've been playing with data-explorer to peruse stackoverflow more and learn some t-sql.
I managed to write this query, which lists out all posts the user has edited and then shows a difference in
Creation vs Activity date and
Creation vs LastEdit date.
I then realized there is a more accurate way to count all edits (As opposed to checking
if( Difference(LastActivityDate,LastEditDate) > 6) then => Post Counts towards badge
But what if I have a case like this post. I edited it nearly 2 years after it was asked. But it was active 10 days ago. So the
Diff(LastActivityDate,LastEditDate) is negative.
- Does that post count toward Archaeologist? (and excavator)
- It should right? I mean the question was inactive for nearly 2 years, and I edited it.
- How would I account for this in my SQL query? (on data-explorer)