Putting in a bit of competition into CB activity

Hi Kyle,
I have a quora-like site for expatriates. I wanted to put in a bit of competition in order to increase user answers. For that I wanted to have a couple of fields in the profile showing how many comments to a certain activity (identifiable by its asset "mainforum") they have made. That should show on their profile (with an associated rank, beginner, knows something, expert, answer master).
Most of all though, I would like to have a module in order to show the person with the highest number of comments or the person with the highest number of activity (again, if possible, only those with a certain asset).

Any possibility to do that?

Easiest way is probably a Query field using CB Query Field then just query for a count of those comments. Example as follows.


Ideally this would just have an inner join of the activity to filter things down, but without the object and target columns (not implemented yet) the query is a little odd, but it works if you want to use that method instead.

Hi just got round to testing it out and having some issues.

I think the queries are not right. I am always getting 0 out of either one.

The problem I think is that I have no clue what I should put in USER_ID_HERE (ie what substitution) as I need to have the persons ID on whose field the Query field is on, not the viewers user ID (for that one I can use [user_id])
The other problem is that I am using the asset "mainforum.[user_id]". Here again I would need the ID of the profile that the query field is on.

The queries work fine in my tests. You need to of course replace ASSET_HERE and USER_ID_HERE. Treat all substitutions as strings so replace USER_ID_HERE with '[user_id]' for example. Substitutions in Query and Code fields are always based off the profile owner data.