Specifies where and how the data is
retrieved from the database, when using a SQL query.
Navigation
- In AgilePoint Envision, open a process template.
- Navigate to the Database stencil.
- On the Database stencil, drag the
Query Database AgileShape, and drop it on the process template.
- To view the entire list of properties, in the Design Tasks pane, click Show Properties.
- On the SQLType list, select SQL.
- On the Configure field, click the Ellipses button.
Field Definitions
| Field Name |
Definition |
Connection String
|
- Definition:
- Specifies the connection string that is used to connect to the database.
- Click
Choose to select a connection string from the list of
shared custom attributes (defined and managed in Enterprise Manager.)
- Click Create to
create a new connection string.
- Allowed Values:
- A valid SQL connection string.
- Default Value:
- server=myserver;database=pubs;trusted_Connection=yes
- Custom Attributes:
- Yes
- Example:
- server=DataServer;database=StoreDb;trusted_Connection=yes
|
Create
|
- Opens the Following Window:
- Database Connection Configuration Window
- Purpose of this Window:
- Creates a connection string with specified information.
|
Choose
|
- Opens the Following Window:
- Browse Custom Attributes Window
- Purpose of this Window:
- Specifies a connection string from a list of shared custom attributes.
|
Add
|
- Opens the Following Window:
- Custom Attribute and Query Window
- Purpose of this Window:
- Specifies adding or editing the SQL query which are executed at runtime.
|
Edit
|
- Opens the Following Window:
- Custom Attribute and Query Window
- Purpose of this Window:
- Specifies adding or editing the SQL query which are executed at runtime.
|
Remove
|
- Function:
- Removes the particular SQL query from the existing list of queries.
|
Parse custom attribute to DateTime format
|
- Definition:
- Parses a specified custom attribute to a valid DateTime format.
- Allowed Values:
- Selected - Parses the custom attribute to DateTime format.
- Deselected - The custom attribute remains in its default data format.
- Default Value:
- Selected
|
Return first row of query
|
- Definition:
- Specifies which record to be fetch from the database.
- Allowed Values:
- Selected - Specifies to fetch the first record in the database column.
- Deselected - The query fetches the last record.
- Default Value:
- Deselected
|
