To delete records from a database, do the
following.
Navigation
- In AgilePoint Envision, open a process template.
- Navigate to the Database stencil.
- On the Database stencil, drag the
Delete Records 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 Configure field, click the Ellipses button.
Instructions
- On the Configuration for Deleting Database Record(s) window,
complete the following fields as required.
| Field Name |
Value |
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
|
Table Name
|
- Definition:
- Specify the name of table from which the database records has to be deleted.
- Allowed Values:
- A valid database table name.
- Default Value:
- None
- Custom Attributes:
- Yes
|
Condition
|
- Definition:
- The SQL WHERE clause that defines which database records should be updated.
- Allowed Values:
- A valid SQL WHERE clause.
- Default Value:
- None
- Custom Attributes:
- No
- Example:
- InvoiceNumber <= 3452
|
- Complete any additional configuration for this AgileShape according to your requirements:
