reading sql query records and end of records question(s)

Below is my current flow of doing a sql query that returns records. I then have a condition to generate an email based upon the value of a particular field. My question is how would I get this flow to go to the next record so after sending the email, I can return to the "Branch" and process the next record.

Then what "condition" would I add to the Branch so when it is out of records so I can then have the process end.

Right now it is sending an email based upon the first record from the query and then ending.

Thank you.

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

unknown

Based on **** things I have done in the past:

Try adding the else/true branch and see if 10 of the 11 records don't end up in it.

Check to make sure the "Generate CSV from resultset" box in the query node is not checked.

If you are running your flow from the server, make sure the most recent version of your flow is uploaded (check rich client or download it from the server to IPD).

All comments

1000817

your branch and email nodes should be between the start and end nodes of the sql query. The SQL Query loop will end when you hit the last record without any special processing.

Connect the SQLquery nodes to the branch and the email nodes to the end-SQLQuery node then connect the End-SQLQuery node to the end node.

unknown

I did that and it still only processed one record and quit.

0712131256598360.doc

unknown

Hi

Did you check the RECORD COUNT of the SQL query?

What are the conditions you check in the Branch Node? Check if the query fetches value other than the conditions mentioned in the branch node? If so create one more condition from Branch Node (condition as true) and connect to the end of the SQL Query node.

unknown

Sorry for delay was off all last week. My SQL query has criteria that only fits the 2 conditions I have in my branch. It processes the first record and then quits.

I checked and the second records matches the criteria. Should I have the email going back to the "NotificationQuery" instead of the "End-Notification". I figured the "End-Notification" would check if it was at the end of record and either end or return back to the query. The log shows the following at the very end..

Activity name:Email4790 id:1 completed @ 11/22/2019 04:07:40.279 PM
Email4790_errorCode = 0
Email4790_informationCode = 0
Email4790_returnMessage = Completed
Email4790_outputData =

Activity name:End id:1 started @ 11/22/2019 04:07:40.279 PM
Activity End: Executing End activity
End_errorCode = 0
End_informationCode = 0
End_returnMessage =
End_outputData =
Use data views: true

Copyright © 2025 Infor. All rights reserved.