Database Queries Window

Use this window to configure 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 AgilePart, and drop it on the process template.
On the SQL Type list, select SQL.
On the Configure field, click the ElLipses button.

Field Name	Definition
ConnectionString	The connection string that will be used to connect to the database at runtime. 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. to create a new connection string.
TableName	The name of the database table where this AgileShape should insert the database record.
Return first row of query	When selected, specifies that specifies to fetch the first record in a database column. When deselected (default), the query fetches the last record.

Field Name

Definition

ConnectionString

The connection string that will be used to connect to the database at runtime.

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. to create a new connection string.

TableName

The name of the database table where this AgileShape should insert the database record.

Return first row of query

When selected, specifies that specifies to fetch the first record in a database column. When deselected (default), the query fetches the last record.