Query Record (Database) activity
An activity that executes dynamic SQL statements or calls stored procedures to get database data.
![Query Record activity](images/cloudenvShapeQueryRecord.jpg)
Configure the Query Record activity
To configure the Query Record activity, do the procedure in this topic.
Good to Know
- In most text fields, you can use process data variables as an alternative to literal data values.
- You can configure whether this activity waits for other activities before it runs.
For more information, refer to How Do I Configure an Activity to Wait for Other Incoming Activities?
- This section shows the configuration settings on the configuration screens for this activity. Other configuration settings apply to system activities. For more information, refer to:
How to Start
- Open Process Builder.
For information about how to open this screen, refer to Process Builder.
- In Process Builder, in the Activity Library,
open the Database tab.
- On the Database tab,
drag the Query Record
activity onto your process.
Procedure
- Complete the fields on the General Configuration screen.
- Click
Query Record
.
- On the Query Record screen, do one of these.
- Complete the fields on the SQL Command tab.
- Complete the fields on the Stored Procedure tab.
- (Optional) Click Advanced
> Email Notifications
.
For more information, refer to Email Notifications screen (Process Activities).
General Configuration
Specifies the basic settings for the Query Record activity.
![General Configuration screen](images/cloudenvSystemBasicConfigurationWinQueryRecordDatabase.jpg)
Fields
Field Name | Definition |
---|---|
Display Name |
|
Description |
|
Database Type |
|
Connection Timeout (Seconds) |
|
Query Record Configuration > SQL Command
Specifies where and how the data is retrieved from the database with a SQL query.
![Query Record SQL Command tab](images/cloudenvQueryRecordSQLConfigWin.jpg)
Fields
Field Name | Definition |
---|---|
Database |
|
Create |
|
Schema Name |
|
Table Name | |
Include Synonyms in the list |
|
Include Views in the list |
|
Add |
|
Delete |
|
Edit |
|
Add New Query |
|
Parse Custom Attributes to Date Time format |
|
Return First Row of Query |
|
Variable and Query Window
Specifies the SQL query that executes when the activity runs.
![Query Record SQL Command tab](images/cloudenvQueryRecordVariableQueryConfigWin.jpg)
Fields
Field Name | Definition |
---|---|
Database |
|
Create |
|
Schema Name |
|
Attribute Name |
|
Data Type |
|
Table Name |
|
Include Views in the list |
|
SQL Select Query |
|
Column Name |
|
Filter |
|
Back |
|
Query Record Configuration > Stored Procedure
Specifies where and how the data is retrieved from the database with a stored procedure.
![Query Record Stored Procedure tab](images/cloudenvQueryRecordStoredProcedureConfigWin.jpg)
Fields
Field Name | Definition |
---|---|
Database |
|
Create |
|
Schema Name |
|
Stored Procedure Name |
|
Parameter Name |
|
Value/Attr. Name |
|
In/Out |
|
Data Type |
|
Size |
|