Database Query Executor
performs a database query
Properties
Common
Name - refers to the unique identifier or label assigned to a node within a flow.
Type | Restrictions |
---|---|
input Text |
|
Description - provides a textual description or additional information about a node within a flow. Unlike the name property, which serves as a unique identifier or label for the node, the description property offers supplementary details that help to clarify the purpose, functionality, or behavior of the node.
Type | Restrictions |
---|---|
Input Text |
|
Specific
Query - query to be executed. You can select any query from the project or its dependencies.
Type | Restrictions |
---|---|
|
SQL - this property appears in the case where the selected query is dynamic.
Type | Restrictions |
---|---|
String Expression |
|
Query parameters - parameters defined for the selected query.
Type | Restrictions |
---|---|
Expression (type depends on the definition) |
|
Optional
Transaction - a reference to the transaction initiated by the BeginTransaction node, to be used for query execution.
You can find more information about database transactions in the appendix section.
Result
A new node variable with type pdk.sql.QueryResult has been added to the flow's scope.
Connections
Type | Min count | Max count |
---|---|---|
in | 1 | * |
out | 1 | 1 |
Last updated