Create view filters in a Lists tool design in SharePoint Workspace 2010

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

You can use view filters to include items in or exclude items from a view based on specified conditions. For example, you can display items created only with specific forms, or display items only if field values match specific criteria.

In this article

Overview: creating a view filter

Adding filter expressions

Overview: creating a view filter

To create a view filter:

1. Open the List tool Designer.

2. Click the view in which you want to apply a view filter.

3. Click the Filter tab.

4. Check or uncheck forms, as needed.

   The view will only show items created with the form templates you have checked.

5. Add filter expressions, as needed, to include or exclude records.

6. Save and publish your design changes.

Top of Page

Adding filter expressions

Filter expressions tests field values, and displays items in the data view when the condition(s) stated in the expression are met.

Adding a filter expression with a single condition

To add a basic expression, do the following:

1. Select the field for which you want to test values from the pop-up list.

   Note: Rich-text fields are available only if their Searchable property is enabled.

2. Select an a condition option from the pop-up list list.

   The condition options you see differ depending on the field type. Text-related fields include options that work with text strings, such as "contains", and "begins-with"; date-related fields include date-specific options such as [IsToday] to indicate today's date.

3. Enter the value you want to test for in the text box.

4. Click to add the expression.

In the example below, the filter expression displays all items in which the value in the "departmentName" field is "Sales".

Top of Page

Adding a filter expression with multiple conditions

You may sometimes need to test for more than one condition. To do so, you can add an expression that contains logical operators. You can create an expression that selects records only if ALL conditions are met (logical AND operator), or if ANY conditions are met (logical OR operator).

In the example below, two conditions are added with the "Logical OR" option selected. The resulting filter expression will display all records in which the value in the "DepartmentName" field is either "Sales" or "Marketing".

Top of Page

Updating a condition in an filter expression

To update a condition, do the following:

1. Select the condition in the expression display box.

   The parts of the expression display in the pop-up lists and value text box.

2. Change any part of the condition.

3. Click

Top of Page

Removing a condition in a filter expression

To remove a condition:

1. Select the condition in the expression display box.

2. Click

Top of Page