CAML Query

An AgilePart that creates a SharePoint view based on available fields using a CAML query. Use the CAML Query Builder AgilePart to create your CAML query, and your view.

Prerequisites

Log on to SharePoint.

Navigation

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

Properties for This AgileShape

Field Name	Definition
CAML Query Configuration	Opens the Following Window: CAML Query Builder Configuration Window - List and View Fields Tab - Creates a view from the available fields, or columns, in a SharePoint list. CAML Query Builder Configuration Window - Where Clause Tab - Configures a Where clause to filter the results of a CAML query. CAML Query Builder Configuration Window - Query Options Tab - Specifies how and where CAML query operations are performed in the SharePoint list － for example, how many SharePoint records need to be retrieved, the folder location where the query needs to be performed, and whether to include the mandatory columns in the CAML query result. CAML Query Builder Configuration Window - Grouping Tab - Groups SharePoint list data by a specified column name, either in ascending or descending order CAML Query Builder Configuration Window - Output Mapping Tab - Maps the SharePoint columns in a CAML query response to the nodes in an AgilePoint or InfoPath schema. CAML Query Builder Configuration Window - Test Query Tab - Verifies whether the specified CAML query is correct.

Field Name

Definition

CAML Query Configuration

Opens the Following Window:

CAML Query Builder Configuration Window - List and View Fields Tab - Creates a view from the available fields, or columns, in a SharePoint list.
CAML Query Builder Configuration Window - Where Clause Tab - Configures a Where clause to filter the results of a CAML query.
CAML Query Builder Configuration Window - Query Options Tab - Specifies how and where CAML query operations are performed in the SharePoint list － for example, how many SharePoint records need to be retrieved, the folder location where the query needs to be performed, and whether to include the mandatory columns in the CAML query result.
CAML Query Builder Configuration Window - Grouping Tab - Groups SharePoint list data by a specified column name, either in ascending or descending order
CAML Query Builder Configuration Window - Output Mapping Tab - Maps the SharePoint columns in a CAML query response to the nodes in an AgilePoint or InfoPath schema.
CAML Query Builder Configuration Window - Test Query Tab - Verifies whether the specified CAML query is correct.

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.