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.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
