Database Query Executor

performs a database query

The Database Query Executor node is a versatile database utility designed to execute SQL queries against a specified database. It facilitates interaction with the database by sending queries and retrieving results. This function is typically used in applications that require database connectivity for data retrieval, manipulation, or storage.


Properties

Common

Name - refers to the unique identifier or label assigned to a node within a flow.

Type
Restrictions

input Text

  • must consist of letters (A-Z or a-z), digits (0-9), underscores (_), or dollar signs ($). However, a class name cannot start with a digit and dollar sign ($)

  • Unique per flow

  • Mandatory

  • Min length: 1

  • Max length: 255

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

  • Max length: 5000

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

  • Mandatory

Query parameters - parameters defined for the selected query.

Type
Restrictions

Expression (type depends on the definition)

  • Mandatory

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