Skip to Content Skip to Menu

šŸŽƒ Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

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

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
8 years 4 months ago #282250 by timstohr
Perfect, that was the information I was missing :)

Please Log in or Create an account to join the conversation.

  • timstohr
  • timstohr
  • OFFLINE
  • Posts: 1091
  • Thanks: 56
  • Karma: 9
8 years 4 months ago #282370 by timstohr
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...

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48459
  • Thanks: 8280
  • Karma: 1443
8 years 4 months ago #282388 by krileon
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.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum