I am building a site which only has 9 total groups split into three categories. I have disabled group creation so the we maintain that pure set of only 9 groups for which users can start discussions. We have modified the category menu to reveal all the cats and the subgroups within it but the ordering seems to be based on creation order. Is there any built in method to sort or is best to
1) delete and start over in sequence
or 2) change table order in database
We also have this issue in the backend where we assign the users to groups. the ordering is not in any specific order.

Hi, Eric.

Group categories are sorted alphabetically.
Groups are sorted by creation time - most recent on top.
I think that best way to reorder them will be to change group creation date in database, in table _community_groups
I tested this solution and it works.

You mean order of assigned members?

Hi Eric,

Both steps are fine, just please make sure if you will do #2 you dont touch the group id.

thank you

I think this will fix my issues. Going to work on it now.......Thank you! Will be sure not to touch the group IDS

I followed your date sequence and it all worked.
I also realized what was controlling the order of the assignment. It is sorting the groups for assignment by "group owner".
So we need to make one admin/user own all and it will sort correctly.

<option value="8">ELW Sustainability & Dissemination </option>
<option selected="true" value="9">PDCP Discovery</option>
<option selected="true" value="2">ELW Discovery</option>
<option selected="true" value="3">EADS Sustainability & Dissemination</option>
<option value="6">EADS Discovery</option>
<option value="5">EADS Application</option>
<option value="7">ELW Application</option>
<option value="10">PDCP Application</option>
<option value="11">PDCP Sustainability & Dissemination</option>

Backend assignment of groups to user seems to be unaffceted by user or creation date.
Do you know what this code uses to render the list? Its not cached that I can see.

<select id="groupid" multiple="true" name="groupid[]">
<option selected="true" value="8">ELW Sustainability & Dissemination </option>
<option selected="true" value="9">PDCP Discovery</option>
<option selected="true" value="2">ELW Discovery</option>
<option selected="true" value="3">EADS Sustainability & Dissemination</option>
<option selected="true" value="6">EADS Discovery</option>
<option selected="true" value="5">EADS Application</option>
<option selected="true" value="7">ELW Application</option>
<option selected="true" value="10">PDCP Application</option>
<option selected="true" value="11">PDCP Sustainability & Dissemination</option>
</select>

Hi Eric,

This is the quick fix, open this file administrator/components/com_community/models/groups.php, find this code :

$query	= "SELECT * FROM " . $db->quoteName( '#__community_groups');

$query	= "SELECT * FROM " . $db->quoteName( '#__community_groups'). " ORDER BY ".$db->quoteName('created')." DESC";