Parent topic: Database
AgileShapes / Database

Query Database

An AgilePart that retrieves database data by executing dynamic SQL statements or calling stored procedures.



Navigation

  1. In AgilePoint Envision, open a process template.
  2. Navigate to the Database stencil.
  3. On the Database stencil, drag the Query Database AgileShape, and drop it on the process template.
  4. To view the entire list of properties, in the Design Tasks pane, click Show Properties.

Properties for This AgileShape

Field Name Definition

Configure
Opens the Following Window:

Opens the one of the following windows, depending upon the setting of the SQL Type field:

DatabaseType
Definition:
Specifies the type of database to be used.
Allowed Values:
  • SqlServer
  • Oracle
Default Value:
SqlServer

ReturnFirstRow
Definition:
Specifies the AgileShape that always return the first record from the database table.
Allowed Values:
  • False - Fetches the last record from the database table.
  • True - Fetches the first record from the database table.
Default Value:
False

SQLType
Definition:
Specifies whether to retrieve the data from the database using a stored procedure, or using (one or more) dynamic SQL statements.
Allowed Values:
  • SQL - Data is retrieved from the database using one or more dynamic SQL statements. If the SqlType property is set to SQL when you click the Ellipses button, it will open a configuration window.
  • StoredProcedure - Data is retrieved from the database using a stored procedure.
Default Value:
SQL
Timeout
Definition:
Specifies the maximum amount of time, in seconds, allowed for the completion of the web service call for the AgileShape.
Allowed Values:
Any positive integer.
Default Value:
600
Custom Attributes:
No

IgnoreFailedQuery
Definition:
Specifies whether the AgileShape continues making database queries if one of the database queries throws an error.
Allowed Values:
  • False - The AgileShape stops making database queries when an error is thrown.
  • True - If a database query throws an error, the AgileShape continues making queries.
Default Value:
False

Common AgilePart Properties

This AgilePart inherits the following common properties. For more information, see AgilePart - Common Setup. Note that only the relevant properties are available in AgilePoint Envision. Unneeded properties are hidden.

Name, (UID), Description, Debug, Audit Level, SessionMode, Wait All Incoming, AssemblyName, ClassName, Method, Optimizing, Activity Entry Message (Email), Task Completed Message (Email), ConfigureAttachments, Reference URL, ExceptionHandlerScope, SaveErrorMessageTo, SaveStatusTo, Configure Yammer Credentials, Retries, HandleException

BPMN Properties

Each AgileShape includes a set of BPMN properties. For more information, see Adding or Modifying BPMN Properties for an AgileShape.

Common AgilePart Tasks

Parent topic: Database

AgilePoint BPMS v5.0 R2 for .NET 3.5, .NET 4.0, and Genesis Edition

AgilePoint BPMS v5.0 SP3 for Universal Edition and Azure

© 2014 AgilePoint, Inc. All rights reserved.