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.
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies