[SOLVED] How to sort GroupJive groups in a catergorie alphabetical?

In Groupjive configuration on the Groups-All-Display tab there's a setting "Select ordering of groups"

This seems to only have an effect when displaying a list of groups as a menu item, and not when displaying a list of groups in a dropdown at registration using cbgjautojoin.

I tried this auto action but am struggling to make it work, please explain what I'm doing wrong.
Type-Query
Triggers-gj_onAfterCreateGroup
User-Automatic
Access-Everybody
Conditional-left as select operator, it say's this is optional
Query Action-
SET @cnt = 0;UPDATE #__groupjive_groups
SET ordering = @cnt := (@cnt+1)
ORDER BY name;

Mode-Internal

I created groups in the front end during registration using another auto action, and also in the back end and the ordering doesn't change.
Regards,
Andrew

The ordering parameter is only used for frontend displays and nothing else. It's also set automatically when saving a new group (ordered first as newest are always made first). If you need to change the order it's best to do it using the PHP API by adjusting the order column then running the update order function. To debug your query ensure Joomla debug mode is enabled and maximum error reporting is set.

Thanks for clarifying this, I will give it a try and use debug mode.