Configures a Where clause to filter the results of a CAML
query. Only the SharePoint records are retrieved that fulfill the criteria
of the Where clause.
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.
|
Where Clause Box
|
- Definition:
- Displays the tree-view structure of the Where clause set for the CAML query. The Where clause is specified using the conditions and logical operators.
- Allowed Values:
- Read only.
|
Select Nest Type
|
- Function:
- Determines the use of logical AND and OR operators to nest conditions for the Where clause.
- And - Specifies the logical AND operator.
- Or - Specifies the logical OR operator.
You must set the nest type first, before defining the condition for the where clause.
|
Configure Condition
|
- Function:
- Sets the criteria that defines which SharePonit list data to be retrieved.
- Column - The name of the SharePoint column.
- Comparer - A list of comparison operators that are used with Where clause.
- Value - The value for the column. You can also specify a custom attribute using the Ellipses button.
|
Delete Condition
|
- Function:
- Deletes the selected condition specified for the Where clause.
|
Save Query
|
- Function:
- Saves the Where clause specified for the CAML query.
Also, displays the code snippet generated for the Where clause, in the code snippet box where you can make changes.
When you make changes in the code snippet box, the Edit and Save Query button appears to save the specified changes.
Once you click the Edit and Save Query button, the changes are reflected in the Where Clause box.
|
Where Clause Code Snippet Box
|
- Definition:
- Displays the code snippet which is generated for the Where clause when you click Save Query. The Where clause is specified using the conditions and logical operators.
- Allowed Values:
- A code snippet.
You can edit the code in the code snippet box. When you make changes in the code snippet box, the Edit and Save Query button appears to save the specified changes.
Once you click the Edit and Save Query button, the changes are reflected in the Where Clause box.
- Default Value:
- A code snippet generated for the Where clause.
|
Common Configuration Tasks
