How to reference column names after SQL QUERY?

This maybe a simple answer, but I have a process right now that does a sql query and then writes output to a file. Before writing to the file I want to add email notifications based upon a column value in my query. So I moved a "BRANCH" node into my flow. How do I reference a column name and a calculated value in the BRANCH node.

Calculated value is "DATEDIFF(day, SYSDATETIME(), PAEMPPOS.DATE_ASSIGN) as DateDiff" in sql query. I am wanting to do a BRANCH based upon the value in my calculated "column".

Thank you

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

unknown

Hello,

I've found that you can do it one of two ways. You can reference the column directly DATEDIFF(day, SYSDATETIME(), PAEMPPOS.DATE_ASSIGN) or use the node and column number i.e. SQLQuery2010_3. I find the latter method to be the easiest when dealing with situations like the above. However, if your column order changes that will cause you issues.

Thanks,

Kyle

unknown

In the flow as you have it pictured, you won't be able to find the column in the SQL query until you connect the branch node. Once connected, it will be SQL Node ID_Column Name.

jreese

you should have a variable in your list with the name of your sqlnode_DateDiff that you can reference.

logo-32.png

unknown

Hi, since you have given the derived column an alias, you should be able to call it by the alias, e.g. SQLQuery1234_DateDiff. Run your flow and look at the output of the query node in the log. You will see all the columns of your query output listed and you can literally cut and paste the name from there into your branch.

unknown

Yes. I understand that. Just added it to show where I was going to place it before writing the file.

unknown

You would do something like SQLQuery_DateDiff == value. You would assign that to one branch. The 'if' is already built into the node.

john-miller

What I do to get my variable names from a SQL node is to put a Debug Breakpoint on the Assign Node right after the query, and then run the Flow Locally. All Variables will be listed in the Console while it runs.

20241009_102714.jpg

unknown

How would that look? Where would you do that. In the ASSIGN node?

john-miller

[View:/cfs-file/__key/communityserver-discussions-components-files/57/Viewing-SQL-Query-Variables.docx:320:240]

Copyright © 2025 Infor. All rights reserved.