You are viewing limited content. For full access, please sign in.

Question

Question

Retrieve all emails in a SQL DB

asked on May 16, 2022

I'm trying to retrieve all of the emails in a db. I'm going to use this to send each person a request to fill out a form via the Invoke Business process. On the first step of query I do get all the records in the DB but I'm not seeing them in the track token part. I only see the first record of the DB. I'm assuming I might  need a for each command? Can someone tell me what I'm missing. PS. I'll be inserting the Invoke Business Process at the end.

Thanks in Advance

Query SQL.jpg
Query SQL.jpg (10.73 KB)
0 0

Answer

APPROVED ANSWER
replied on May 16, 2022

You need a "For Each Row" activity to address each result from your query.

1 0

Replies

replied on May 16, 2022

Thanks, that worked nicely!!!!

1 0
replied on May 16, 2022

Happy to help!

Please consider marking the questions as answered, and have a wonderful day!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.