Column Filtering

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

• Values in one column using the filtering icon
• Values in more than one column 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 .

When a filter has been configured for a column, the Remove Filtering icon appears to the right of the 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 beneath the Filtering column heading.

*The Lightning Conductor Web Part can also be filtered using web part connections. For example, you can use the Current User Filter Web Part connected to the Assigned To column to display only items assigned to the person who is displaying the page; however, to use web part connections when configuring the Lightning Conductor Web Part, you must also select either the Use Only Dynamic Filters radio button, or the Use Both Dynamic & Persistent Filters radio button in the Filtering Settings section on the Data Source tab.

To connect the Lightning Conductor Web Part to consume data from another Web Part, on the Lightning Conductor, Web Part menu, click Connections to display the Choose Connection dialog. To see the Connections link on the Web Part, the page must be in edit mode.

Advanced Filters

Occasionally, you may want to filter on more than one column using And or Or operators. This can be done with the Lightning Conductor Web Part using the Advanced filtering link, which is displayed in the top right of the Columns Configuration section of the Columns tab.

To filter on more than one column:

1. Click the Advanced filtering option in the top right hand corner of the Columns Configuration 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. Additionally, you can set filters that are to be applied after the data is retrieved.
   
   
   

Columns Configuration →