Would it be possible to get a column added for badge count? I have a lot of badge…um…hounds, yeah that’s the PC word, and they want to see at a glance who is in the lead in terms of collecting the most badges.
It’s not planned or on any roadmaps at the moment.
Thanks for the info - has anyone else asked for something like this, to your knowledge, or am I the lone requestor
I would really really like this too.
Ruby is a weird foreign language to me, and SQL beyond simple SELECT and maybe GROUP BY gives me hives, but … as I understand it, the things in the user page can be those from the
directory_items table, which is constructed by SUMming and COUNTing things in various user tables, in directory_item.rb.
In user_stat.rb, I find a
distinct_badge_count, which would be fine if this were for all time, but we want the various leaderboard time periods, and also for this purpose probably don’t want
I think maybe all that’s needed is to add to the gigantic SQL query to count from
user_badges where the
granted_at date is after
Oh, although I guess also it needs to check and only count the badges that are enabled.
I’m not sure about the technical difficulty of adding badge counts to the users page, but now that we allow optional directory items to be added to the users page, it seems that badge counts would be a logical addition. It would help to make the users page function more as a leaderboard.
Just a thought, but would adding a
badges_received column to
directory_items be a possible way of approaching the issue?