Auto Action for User Group based on User Connection

Thru "Manage Connections" members can designate other members into a "Judge" type in _comprofiler_members

I have a Judge Menu Item, a Judge User Group and Judge AL

I have a cb_connectiontypes query field in screenshot 1 which captures "type" in _comprofiler_members

I built a Auto Action in CB, Plugins, Auto Actions, in screenshot 2 to add a Athlete user to the Judge User group when fired.

The trigger should fire upon login or after login.. but i can't seem to get it to work. I think the issue is that the query returns multiple rows and I have the "Output" in cb_connectiontypes set to "single row" "single column".

Any Thoughts? Query works fine in phpMyadmin

Type in database is Value1|*|Value2|*|Value3, etc.. so you'll want to use Is REGEX to match against it as follows.

[cb_field] Is Regex /Value1/

This should ensure it matches no matter how many types a user has.

just confused by Regex see below.

OK showing screen shots as I was not matching to query

Shot 1: regex conditional

Shot 2: db query

sorry... still stumped. using Is Regex /9/

which should hide those in user groups 9. Correct.

You need to know what "User Groups" field is for the user. Check _comprofiler and see what's stored in database then determine the correct operator and value based off what is stored.