Query Records (PostgreSQL) activity
An activity that retrieves one or more records from PostgreSQL.

Configure the Query Records activity
Prerequisites
- AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v8.0 Software Update 2 or higher.
Good to Know
- To send an email notification, click
Advanced
> Email Notifications
.
For more information, refer to Email Notifications screen (Process Activities).
- 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 PostgreSQL tab.
- On the PostgreSQL tab,
drag the Query Records
activity onto your process.
General Configuration
Specifies the basic settings for the Query Records activity.

Good to Know
- Documentation for this screen is provided for completeness. The fields are mostly self-explanatory.
Fields
Field Name | Definition |
---|---|
Display Name |
|
Description |
|
Query Records Configuration
Specifies the information about the records to retrieve from PostgreSQL.

Fields
Field Name | Definition |
---|---|
PostgreSQL |
|
Create |
|
Schema |
|
Table Name |
|
Condition |
|
Column Name |
|
Filter |
|
Order By |
|
Sort By |
|
Row Limit |
|
Map Request To App Schema |
|