Column Filtering

You can filter the number of items displayed within the Data Viewer Web Part, based on one or more conditions using:

• Values in one column using the filtering icon
  
  
• Values in more than one columns using the Advanced filtering link.
  

Both of these options are detailed on this page.

Filtering icon

Filters can be configured on each column whether the column is displayed or not. Each column type can also provide different filtering options, for example, a Date/Time filter allows you to filter by [TODAY], a People column allows you to filter by [Me], and so on.

You can apply the filter and remove the filter using the filtering icon , which displays the Filter Configuration dialog.

Select the condition from the drop down list, type a value in the text box and then click the green plus icon . A dialog displays stating that the filter configuration was updated successfully.

When a filter has been configured for a column, then to the right of the Filtering icon , is the Remove Filtering icon . This allows you to easily identify columns that are being used to filter the contents returned from the rollup query. To remove all persistent filters, click the Remove Filtering icon, just under the Filtering column heading.

*You can also use Web Part connections to filter the contents of a Data Viewer Web Part.

Advanced Filters

Occasionally, you may want to filter on more than one column using And or Or operators. This can be done with the Data Viewer Web Part using the Advanced filtering icon, which is display in the top right of the Columns section of the Columns tab.
.
To filter on more than one column:

1. Click the Advanced filtering icon in the top right hand corner of the Columns section on the Columns tab.
   
   
2. Click the green plus icon to add a new level of filtering.
   
   
3. Select the column to apply the filter to.
   
   
4. Select the operator such as Equals.
   
   
5. Set the value.
   
   
6. You can repeat these steps for each column that you wish to filter on.
   
   
   

Columns tab →