Process Activities / Database tab |
An activity that executes dynamic SQL statements or calls stored procedures to get database data.
To configure the Query Record activity, do the procedure in this topic.
For more information, refer to Configure General Options for a Database activity..
For more information, refer to Get Data from a Database.
For more information, refer to Configure E-mail Notifications for Any Activity
Specifies the general information for a Database activity.
Field Name | Definition |
---|---|
Display Name |
|
Description |
|
Database Type |
|
Connection Timeout (Seconds) |
Specifies where and how the data is retrieved from the database with a SQL query.
Field Name | Definition |
---|---|
Database |
|
Add Token |
|
Add |
|
Delete |
|
Edit |
|
Add New Query |
|
Parse Custom Attributes to Date Time format |
|
Return First Row of Query |
Specifies the SQL query that executes when the activity runs.
Field Name | Definition |
---|---|
Database |
|
Add Token |
|
Attribute Name |
|
Data Type |
|
Table Name |
|
SQL Select Query |
|
Column Name |
|
Filter |
|
Back |
Specifies where and how the data is retrieved from the database with a stored procedure.
Field Name | Definition |
---|---|
Database |
|
Add Token |
|
Stored Procedure Name |
|
Parameter Name |
|
Value/Attr. Name |
|
in/out. |
|
Data Type |
|
Size |