SQL Server

SQL Server - Get result field

SQL Server - Get result field

Gets the value of a specific field (column) from a result row. It can be used inside a SQL Server: For each result loop or after a SQL Server: Get single result action.

Options

Result

Reference to the SQL Server: For each result or SQL Server: Get single result action the field will be read from.

Field

Name of the column whose value will be read, for example Nome or DataNascimento.

Returns

Javascript code

js

actions["action-id"].value // value of the selected field (Any)

Field selection

• value — value of the selected field of the result row (Any)

Rules and Conditions

• The Result and Field fields are required.
• The Result field must reference a SQL Server: For each result or SQL Server: Get single result action.
• The field name must match exactly the name of the column returned by the query.