SQL Result Row node
An SQL Result Row node is a record of a row of data returned when executing a SQL query against a remote database. Therefore any Integration-Result-node will have one or more SQL Result Rows related to them.
It is the data in the SQL Result Row nodes that is consumed by patterns.
SQL Result Row Lifecycle
The following section describes the scenarios in which an SQL Result Row is created,updated or destroyed.
Creation
SQL Result Row nodes are created when the related Integration-Result-node is created, as the result of running a SQL query.
Update
SQL Result Row nodes are never updated.
Removal
SQL Result Rows are removed when the related Integration-Result-node is destroyed.
Attributes and relationships of the SQLResultRow node
The attributes of the SQLResultRow node are described in the following table:
UI Name | Description |
|---|---|
Index | Position of item within results |
The relationships of the SQLResultRow node are described in the following table:
UI Name | Relationship | Description |
|---|---|---|
SQL Query Result | Member: List: List: DiscoveredSQLQuery | List this SQL Result Row belongs to |
Integration Result | Member: List: List: IntegrationResult | List this SQL Result Row belongs to |