What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

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 LastEditorUserId)

After looking around I found two posts that sorta explain how the excavator badge is calculated. It suggests

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)
share|improve this question

1 Answer 1

If it was active 10 days ago, then it doesn't count towards the badges because it hasn't been inactive for a period of 6 months. They're not for editing posts which are at least 6 months old.

Edited 100 posts that were inactive for 6 months

I think your question more brings up the point of whether the word "were" means:

  1. The post was inactive for a period of 6 months somewhere in its history at the time of editing.

  2. The post has been inactive for a period of 6 months at the time of editing.

The wording tends to lean towards case 1, although I think the badges are awarded for case 2.

I am sure, though, that it counts the activity of the post at the time you edited it, not the current activity of the post after you edited it, say, 4 months ago.

share|improve this answer
But when I edited it, it wasn't active for a year. If it doesn't count, then any post you edited that was inactive for 6 months could be made active by doing something on it. Like the post I earned excavator for. If you add a comment today, LastActiveDate is today, does that mean the post doesn't count for Archaeologist ?? –  gideon Mar 4 '12 at 7:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .