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.
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.
- On the CAML Query Configuration field, click the Ellipses button.
Field Definitions
| Field Name |
Definition |
Site URL
|
- Definition:
- Specifies the URL for your SharePoint site.
- Allowed Values:
- A valid SharePoint site URL.
- Default Value:
- None
- Custom Attributes:
- Yes
- Example:
- http://mysharepoint:8000/sites/${mysite}
|
Connect
|
- Function:
- Retrieves all the SharePoint lists and document libraries of the specified SharePoint site to the List Name list.
|
Row Limit
|
- Definition:
- Determines the maximum number of rows to be retrieved using the CAML query.
By default, 10,000 records can be fetched from the CAML query.
- Allowed Values:
- Deselected - Specifies that maximum 10,000 records can be fetched from the CAML query.
- Selected - Retrieves the specified number of records.
- Default Value:
- Deselected
|
Include Mandatory Columns
|
- Definition:
- Specifies that mandatory columns are included in the CAML query results.
- Allowed Values:
- Selected - The mandatory columns are included in the CAML query results.
- Deselected - The mandatory columns are not included in the CAML query results.
- Default Value:
- Selected
|
Specify a folder
|
- Definition:
- Specifies the location of a folder you want the CAML query to be executed.
- Allowed Values:
- Selected - The AgileShape executes the CAML query at the folder location.
- Look in all folders and sub folders - The CAML query is executed in all the folders and their subfolders.
- Specify a folder Url - The CAML query is executed only in the specified folder.
- Deselected - The AgileShape executes the CAML query in the entire SharePoint database.
- Default Value:
- Deselected
|
Common Configuration Tasks
