RPASQL 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

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 name 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.