[SOLVED] In what ways do Auto-action vs subs SQL action get fired

Perfect, that was the information I was missing

Still cracking my teeth on this. I cannot use the trigger "FirstLogin" but need to use the trigger "OnBeforeUserUpdate" (don't ask, bug in the system that breaks a LOT down the line if I change it so as a fast rememdy I need the below).

As I am adding a row in a table and dont want hundreds of identical columns, I need to condition it. What condition do I need to use in auto action to put in as condition: If table #__js_userroles , column "UID" does NOT have an entry for [user_ID] then it should fire. If it has, then it should NOT fire.

I can do the conditions without any problems on comprofiler table but have difficulties getting my head around the 3rd party plugin tables...

Just add that to the query as part of the WHERE. CB Auto Actions can not do a query inside of the conditions unless you've a CB Query Field setup to do that then substitute in that field to condition against, but it's more efficient to just make it a part of your query. As you're doing an INSERT then a subquery would be your best bet.