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
Attribute Name and Type

Description

Index
__index : int

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*