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

Help with simple SQL activity script

Avatar

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
edwardr28531298
Level 2

Likes

8 likes

Total Posts

18 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
edwardr28531298
Level 2

01-03-2021

Hello, I would like some more information on how to use the SQL activities in adobe campaign classic.

let's say for example Instead of using the generic query editor to query the recipient's table for email = "helloworld@123domain.com" I wanted to use the SQL activity and write:

SELECT T0.[iRecipientID], T0.[sEmail] FROM [neolane_application].[NmsRecipient] T0 WITH (NOLOCK) WHERE T0.[sEmail] IN ('helloworld@123domain.com')

 

the activity runs without any errors, but it does not return an actual result much as the normal query activity would, it just flashes blue as it ran successfully.

is there something else that needs to be added to the SQL activity? thank you.

query sql

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

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

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

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

01-03-2021

Hi,

 

Use a 'JavaScript code' activity in a workflow. Return value will be in the Audit tab of the workflow:

logInfo(sqlGetString('select ...'))

 

Thanks,

-Jon

Answers (0)