4

I understand badges are a way for users to track their achievements while helping the community. Usually there is a way for the user to know how far he is from obtaining a new badge, specially for those badges that require you to do a determined amount of X (being X upvotes on questions or answers, for instance). Specific for the Pundit badge the user is required to have 10 or more comments with a score of 5 or higher.

My question is: is there a way for a user to know how many of his comments have a score of 5 or higher? I'm aware that there is a comments tab under all actions, but it only shows my comments, not their present score.

1 Answer 1

Reset to default
5

For such question, there is data.SE. Apparently, someone thought about it too, so there is a query for this badge. I let you run it with your user id and on the right site. I suppose you can search on data.SE for any badge, someone probably wrote a query for it.

As you mentioned, the query did not order the comments as one can expect. I clicked on the column to sort it as I wished. But a better way is I forked the query and edited it for the right purpose: here you can see your sorted comments. Feel free to fork it and customize it as you like, the language is standard or close to standard SQL, and the tables are described on the right panel.

Good luck catching the badge, apparently you're on the right track!

2
  • Nice! I didn't know about data SE. Only one thing, the comment to the query you provided says "List comments in order of score", but it's order by clause is "ORDER BY Posts.ParentId,Posts.Id", so it is actually ordering by a comment's ids and not by it's score. Can the query be fixed? If yes,how to do it?
    – gmauch
    Commented May 14, 2015 at 13:30
  • @gmauch there are multiple ways, I updated the answer with the forked query.
    – Vince
    Commented May 14, 2015 at 14:04

You must log in to answer this question.

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