SQL queries and vaiables

Welcome to our english speaking user community.
Feel free to ask questions or share your knowledge with peers.
Post Reply
reseke
Posts: 6
Joined: 14. Sep 2022, 13:20
Location: Berlin, DE
Contact:

SQL queries and vaiables

Post by reseke » 23. Feb 2023, 12:04

Hello all,

Working on a workflow that uses SQL queries. They create a list of rows. I can iterate on those, but I can not find a way to use the column data in those rows.

Example:
I have a that sorts to a temporary table directly from SQL.

Code: Select all

CLIENT_ID	        SERIAL	        CUSTOMER	ASSET_STATUS	TEMP_CPU	FAN_CPU	SMART_STATUS	DISK_USED
CAGO0100xxxx		B004xxx		Dive Angola	productive	30		1986 	0		96
The SQL query is run by the workflow SQLQuerey action. Which loops over the found rows. For each row, I have a nested flow to run actions based on the data found by the query.

I can loop over the number of rows, but how can I get the data form the rows?
When I iterate on a new row how can I find the value of 'Serial' or 'Disk Used' for the current row?

With this information I can create Incident tickets and emails automatically, which is the main goal of my work.

Does anybody know how to pull the column values?

Thank You,

Post Reply

Return to “English”

Who is online

Users browsing this forum: No registered users and 4 guests