tobiaseigen inquired about not receiving the EMPATHETIC badge despite giving over 1000 likes and receiving over 500 likes. jomaxro clarified that the badge requires 500 liked posts, not just 500 likes. tobiaseigen asked for an easy way to determine the number of different posts liked, and Mittineague provided a Data Explorer SQL query to help. tobiaseigen discovered that they had only liked about 250 posts and thus didn’t meet the badge criteria. The discussion then shifted to the idea of displaying badge criteria or progress, with sam suggesting that showing the count for the EMPATHETIC badge would be helpful, and Mittineague and tobiaseigen agreeing that revealing badge criteria or making them reasonably discoverable would be a good idea.
Hi all - my 11 year old son and I were looking over the badges on my site and he pointed out that I should have received the EMPATHETIC badge for receiving 500 likes and giving 1000 likes. It appears I have not.
Has anyone else had this issue, or have a suggestion? Is the query working?
My profile: https://community.namati.org/user/tobiaseigen
You need to have 500 liked posts, not just 500 likes. Can you confirm that 500 different posts have been liked?
ah - that makes sense. is there an easy way to determine the number of different posts that have been liked?
Data explorer? Would need to write up some SQL…
lol I just did out of curiosity.
I was a bit surprised the badge query uses the posts table instead of the badge_posts view.
Anyway, try this
(you’ll need to know your id number)
-- [params]
-- int :the_user_id = 2
SELECT COUNT(posts.like_count) AS liked_posts
FROM posts
WHERE posts.user_id = :the_user_id
AND posts.like_count > 0
Nice! 
I guess I am not as empathetic as my son would like to believe. Only about 250 posts liked.
Yes, it might not be such a good idea to show the progress towards achieving a Trust Level, but I think revealing the criteria for most of the Badges would be harmless enough.
Or at least the criteria should be reasonably discoverable. If it’s so important, perhaps the “number of posts liked” should be one of the metrics shown on the user summary page.
