SQL Activity in workflow | Community
Skip to main content
nitesha38268385
nitesha38268385
Level 2
Sep 16, 2020 2:20 PM UTC
Solved

SQL Activity in workflow

Hi Folks,

 

I want to use the SQL activity in the workflow and found that there is an option to use Conditional content in the SQL Code.

 

 

 

Just want to know, how to use the field name(highlighted in black) from the temp table in the workflow?

 

 

Thanks,

Nitesh.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
Sep 21, 2020 5:50 AM UTC

Hi,

 

That's a JS tag. The editor control you have open is the standard JS personalization one, <FIELD> just means left hand side of the == op.

NB You generally want to avoid using SQL activities/granting users SQL right, unless there's a perf issue that requires custom non-sproc code to resolve.

 

Thanks,

-Jon

View reply

1 reply

Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
Sep 21, 2020 5:50 AM UTC

Hi,

 

That's a JS tag. The editor control you have open is the standard JS personalization one, <FIELD> just means left hand side of the == op.

NB You generally want to avoid using SQL activities/granting users SQL right, unless there's a perf issue that requires custom non-sproc code to resolve.

 

Thanks,

-Jon

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...