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
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,