Question on designing a flow

Your flow will use:
- the "query" node to retrieve the data from the PRSYSTEM table (it will create a loop over the records)
- messagebuilder node (inside loop) to take the data returned for each record from the query node
- email node (after the loop) to send the email built by the messagebuilder.

You can check out my article on using the query node (as well as message builder and email nodes towards the bottom).
https://www.lawsonguru.co...-Query-DME-Node.aspx

Thanks...I got most of it figured out on my own. I guess I was missing the message builder. I have a yes / no branch after the query to decide to email the person or not.

I have a query checking the PRS_AUTO_EMPLOYEE field on HR00 to see if it is set to Yes or No.

My query returns the Y or N (you can see below)...but my branch seems to error to error when I check to see if that QRY returns Y or N


Activity started: QRY (Run Id: 6)
S3 Query QRY: Executing S3 query: PROD=PROD&FILE=PRSYSTEM&FIELD=AUTO-EMPLOYEE&OUT=CSV&DELIM=,,
QRY_errorCode = 0
QRY_informationCode = 0
QRY_returnMessage = Query completed.
QRY_outputData =
QRY_currentPage = 1
QRY_complete = true
QRY_recordCount = 1
QRY_hasNext = false
Activity completed: QRY
QRY_RECORD_COUNT = 1
S3 Query QRY: Executing loop 1 of 1

Activity started: QRY (Run Id: 6)
QRY_AUTO_EMPLOYEE = Y

Activity started: End-QRY (Run Id: 0)

Activity started: Branch480 (Run Id: 6)
Branch Branch480: Executing this branch node...
Activity Branch480: Error evaluating expression: QRY_AUTO_EMPLOYEE == N
Branch Branch480: evaluating branch rule QRY_AUTO_EMPLOYEE == N to node Email1700
Branch Branch480: evaluating branch rule true to node End
Branch Branch480: Next activity to be executed is End
Activity completed: Branch480

put the N in double quotes:
QRY_AUTO_EMPLOYEE == "N"