Skip to Content Skip to Menu

Auto action query to only apply to user substitution

  • Buzz50
  • Buzz50
  • OFFLINE
  • Posts: 180
  • Thanks: 10
  • Karma: 2
10 years 6 months ago #243770 by Buzz50
How to I use substitution to make this query only apply to the user whose action activates it?

UPDATE `buzz5048_joom109`.`wxo_comprofiler` SET `cb_buzzing` = 'Type in here what you are feeling, thinking or anything else that is on your mind at the moment in 240 characters or less...' WHERE

Buzz50
Mike
Buzz50 Seniors
'Head Buzzer'

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
10 years 6 months ago #243785 by nant

Buzz50 wrote: How to I use substitution to make this query only apply to the user whose action activates it?

UPDATE  `buzz5048_joom109`.`wxo_comprofiler` SET `cb_buzzing` = 'Type in here what you are feeling, thinking or anything else that is on your mind at the moment in 240 characters or less...' WHERE


You need to use the user_id field in your WHERE clause.

See examples here:

www.joomlapolis.com/support/tutorials/107-use-cases

and specifically look at these:

www.joomlapolis.com/support/tutorials/107-use-cases/18219-cb-auto-actions-changing-approval-workflow-based-on-cb-field-value

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

Moderators: beatnantkrileon
Powered by Kunena Forum