Configure Lookup for SharePoint > CAML Query Name/Value > Where Clause tab

Configures a Where clause to filter the results of a CAML query.

Good to Know

Some information about third-party integrations is outside the scope of the AgilePoint NX Product Documentation, and it is the responsibility of the vendors who create and maintain these technologies to provide this information. This includes specific business uses cases and examples; explanations for third-party concepts; details about the data models and input and output data formats for third-party technologies; and various types of IDs, URL patterns, connection string formats, and other technical information that is specific to the third-party technologies. For more information, refer to Where Can I Find Information and Examples for Third-Party Integrations?

How to Start

On the Application Explorer screen, do one of these:
- Open an eForm.
- Create an eForm in a Process.
Do one of these:
- Add your form control:
  1. On the eForm Builder screen, in the Toolbox, open one of these tabs:
    - Common Controls
    - Advanced Controls
    - Telerik Controls
  2. On your tab, drag one of these controls onto your form:
    - Auto-Suggest
    - List Box
    - Subform
    - Check Box
    - Auto Lookup
    - List View
    - Pop-Up Select
    - Drop-Down List
    - Auto-Suggest
    - Chart
    - Data Grid
    - Drop-Down List
    - Data Grid
    - Multi-Select List Box
- Change your form control:
  1. On your eForm, click the control, and click Edit .
On the Configure tab, click Add Lookup .
On the Select Data Source Type screen, select SharePoint , and click Next.
On the SharePoint Type screen, select SharePoint Lookup.
On the Lookup Details screen, select Name/Value, and click Next.
On the Configure Lookup screen, click the Where Clause tab.

Fields

Field Name	Definition
Site URL	Function: Specifies the URL for your SharePoint site. Accepted Values: A valid SharePoint site URL. Default Value: None Accepts Process Data Variables: Yes Example: http://[machine name]:[port]/sites/[site name] Note: You must include the /sites in the Site URL for the site to be created successfully. Form Based Applications – SharePoint Data Source
Configuration Mode	Function: Specifies how to configure the WHERE clause for the lookup. Accepted Values: Quick Configuration - Lets you quickly create a WHERE clause to configure the lookup. Manual Configuration - Lets you manually create a WHERE clause to configure the lookup. You can select Manual Configuration if you select Multiple Columns in the Lookup Details for SharePoint screen. When you select Manual Configuration, only the CAML Query, Test Query, and Error Messages tabs are available for configuration. Default Value: Quick Configuration
Fields	Function: Specifies the name of the SharePoint column. Accepted Values: Read only. Default Value: A list of names in the specified list. Accepts Process Data Variables: No
Add Condition	Function: Creates a condition row.
Select Nest Type	Function: Specifies 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.
Column	Function: Specifies the name of the SharePoint column. Accepted Values: A valid SharePoint column name. Drag the name the column from the Fields field and drop it into the Column Name field to build a condition. Default Value: None Accepts Process Data Variables: No Example: Title
Comparer	Function: Specifies the operator to use in your WHERE clause. Accepted Values: = != Contains Begins with Is Not Null Is Null Default Value: =
Value	Function: Specifies the value for the column. Accepted Values: A valid column value. Default Value: None Accepts Process Data Variables: Yes Limitations: Some information about third-party integrations is outside the scope of the AgilePoint NX Product Documentation, and it is the responsibility of the vendors who create and maintain these technologies to provide this information. This includes specific business uses cases and examples; explanations for third-party concepts; details about the data models and input and output data formats for third-party technologies; and various types of IDs, URL patterns, connection string formats, and other technical information that is specific to the third-party technologies. For more information, refer to Where Can I Find Information and Examples for Third-Party Integrations?
Delete	Function: Deletes the row.