[SOLVED] Placing a user on top of a list

You said that was done by using a usergroup. So at this point I'm just as confused as you are. I was explaining how to use the usergroup in the order by statement of the userlist query.

Sorry, you'll need to better explain how this is intended to be setup as I don't understand the relationship between group, chairman, and user. If the group is just a usergroup and not a GJ group then a CB field would probably work best (probably a select field) and then you could just sort your userlist by that field first.

I'm really sorry for confusing the question.

Ok, I have a set of users.

Some of them participate in different groups.

We have a 'board' 'juniorgroup' 'equipment group' 'tripgroup' etc.
Each of these groups have different responsibilities, and each of them has a chairman.
Currently I'm just using Joomla Groups, I've taken a short look on GroupJive, but haven't currently installed it, as I didn't see it solve this for us (I'm not done looking at it, but it doesn't really play well with 2.0 yet I think).

So to get back to the point.

Board:
Chairman: Søren
Members: Kenneth, Lian, Martin, Steen, Birger

Juniorgroup:
Chairman: Birger
Members: Henrik, Simon, Søren, Jørgen

Equipmentgroup:
Chairman: Jørgen
Members: Birger, Simon, Mads

Tripgroup:
Chairman: Simon
Members: Kenneth, Birger

So as you can see each chairman can be a regular member in another group, and vice versa. So I'm not sure how to create the select field, other than create a bunch of select fields, one for each group.

As a user can be chairman of 1 group and a group can only have 1 chairman I'd just create a dropdown with the groups as the values and select which one the user is a chairman of. So you'd have the below options for example.

Option 1: Board
Option 2: Juniorgroup
Option 3: Equipmentgroup
Option 4: Tripgroup

Then you'd edit them and select which they're a chairman of. You could do the same for Member except use a multi-select.

GroupJive has a structure in place that could probably handle this though. The chairman would be the group owner and members would just be users of the group.

Yes, that sounds like a probable solution. An extra field for the user
That will mark a user as chairman, though I can have multiple chairmen this way.
How do I then make the list sort it so that the user that has the right 'chairman' post to be at the top, and not any of the other group chairmen?
I'm not sure if a group owner will work, as these chairmen often change every year.

You'd add a sort by for that field. Your other users won't have a value selected at all so the chairman who has a value selected should be ordered first. If you need more refined ordering of those values you'll need to add the custom SQL for it by toggling Advanced usage of Sort By to supply your own Order By SQL to be added to the userlist query.

The only way I could figure it out was that I've created a field for each group, as a checkmark, and sort for that field in the list.
Now, it currently shows Yes and No, is it possible to get it to show a Checkmark insted?