Autoaction change group based on a custom query

Good morning,
I should use Auto Action plugin using login trigger to check on a user field is included in the result of a custom query, then change its group.

I have to check that a particular number given by the user is among those enabled in a custom table in the database.

How can I do?

Thanks

You'd use a usergroup action on the after login trigger in that case. Auto Action conditions support custom queries so checking a value in a separate database table won't be a problem. Example as follows.

Global
Triggers: onAfterLogin
Type: Usergroup
User: Self
Access: Everybody
Conditions
Condition 1
Field: Usergroups
User: Action User
Operator: Does Not Have
Usergroups: USERGROUP_HERE
Condition 2
Field: Query
Custom Query: YOUR_SQL_HERE
Operator: Equal To
Value: PARTICULAR_NUMBER_HERE
Action
Method: Add Usergroups
Groups: USERGROUP_HERE

The conditions ensure they don't already have the usergroup you want to assign them and check against the result of your database query.

Thanks for the reply.

I add a condition:
my_field
NOT EMPTY

This because some user coult leave empty the field.
But if user don't have the fileld when the user login he get the following error:

:: Action 100 :: Condition 1-4 failed for user 667 with "" Not Empty ""

But if user don't have the fileld when the user login he get the following error:

Turn off debug mode for the auto action. It only outputs debug information if you have debugging enabled in it. The condition is working correctly as empty field value is indeed empty so it fails the not empty check.

That work!
Thank you!