Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

SQL Activity in workflow

Avatar

Avatar
Validate 1
Level 1
nitesha38268385
Level 1

Likes

0 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
nitesha38268385
Level 1

Likes

0 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
nitesha38268385
Level 1

16-09-2020

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.

conditional_content.png

 

 

 

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

 

 

Thanks,

Nitesh.

sql workflow activities

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

20-09-2020

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

Answers (0)