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

Question

Question

performing an action based on each row in my sql table

asked on November 6, 2023

I have an existing sql table of about 55 rows. I need an action to be performed on each row in the table. One of my columns defines the action to be taken. The action is to send an email which content is based on the "User Type" is what will drive which email. The column consists of 2 types "member" and "non-member". I am new to Workflow Designer and am getting stuck in the Query Criteria section.

I will need tokens to populate the finished email to make it more personal.

The above is where I've landed after much adding and deleting. What am I missing in the query criteria? Basically, there is nothing to query, I need all rows of the table itself.

0 0

Answer

SELECTED ANSWER
replied on November 6, 2023

If you just need to return all rows in your table, use the Custom Query workflow activity.

2 0

Replies

replied on November 6, 2023

You should be able to remove the criteria entirely. You only need to add/set values when you want to filter on values from one or more columns.

To return everything, it should look like this

1 0
replied on November 7, 2023

I keep trying to mark yours as 'mark as answer' and the other, but it will only allow one. I wanted to be sure the forum knows both of these solutions was the answer. Thank you!!!

0 0
replied on November 7, 2023

THANK YOU BOTH!! Both of the query resolutions worked!!! I'm having other difficulties, but am going to try to work through them first. Thanks again!

0 0
replied on November 7, 2023

I did end up still needing assistance on the other problems I'm having: https://answers.laserfiche.com/questions/213165/For-each-row-action-is-only-acting-on-first-row-in-custom-query

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

Sign in to reply to this post.