Filter Web Part. Controls and Column Types

2/21/2020
Applies To: List Filter Web Part
Environments: SharePoint 2013 Server, SharePoint 2016, SharePoint 2019

This article describes filtering controls provided by Vitextra Filter Web Part for SharePoint and supported column types.

Introduction

Vitextra List Filter Web Part has more than ten special filtering controls to search for data with SharePoint Lists and Document Libraries. You can use SharePoint native controls such as People Picker or Term Picker as well as special ones: Autocomplete, List with multiple selections, and others.

Vitextra Filter Web Part can be applied to any type of SharePoint List: Tasks List, Document Library, Image Library, Contacts, Custom Lists, and others.

Filtering Controls

Vitextra Filter Web Part has 14 different controls, some of which can be used to filter data of different types of columns, and some are created specifically for certain types of columns, such as People Picker, and Yes/No control.

Text

Text filtering control

Text control

Text controls allows to filter the column by text value. Only the items where the columns contains the filter criteria. The control is ignored if it does not hold any value.

📝 Note
Filter query generated by Vitextra Filter Web Part is case-insensitive.
For example, filter criteria Vitextra and VITEXTRA are the same.

Supported column types:

  • Single line of text
  • Multiple line of text
  • Choice (Multi Choice)
  • Number
  • Currency
  • Lookup
  • Hyperlink or Picture
  • Calculated
  • Computed
  • Managed Metadata
  • Approval Status

📝 Note
Filtering by lookup column is only available by its Value, not ID.

Text with options

Text with options filtering control

Text with options control

Text with options filtering control allows to choose operator which used to search data. The operator specifies how filter criteria relate to one another. List of filter operators supported by List Filter Web Part presented in the following table

Operator Uses
is equal to Use for an exact match.
does not equal to Shows items that do not have the value you enter.
begins with Use when you know what the column value starts with.
is greater than Use when you want to retrieve items that column value exceeds the value you enter.
is greater than or equal to Use when you want to retrieve items that column value matches or exceeds the value you enter.
is less than Use when you want to retrieve items that column value less than the value you enter.
is less than or equal to Use when you want to retrieve items that column value less than or equals to the value you enter.

Supported column types:

  • Single line of text
  • Multiple line of text
  • Choice (Multi Choice)
  • Number
  • Currency
  • Lookup
  • Hyperlink or Picture
  • Calculated
  • Computed
  • Approval Status

Autocomplete

Autocomplete filtering control

Autocomplete control

Autocomplete control shows up to 20 suggestions once user input at least one character.

Important
Suggestions provided by autocomplete control may contain values from items that the current user does not have permissions to view.

Supported column types:

  • Single line of text
  • Person or Group
  • Managed Metadata

List

List filtering control

List control

List with multiple selection filtering control

List with multiple selection control

List control makes it possible to select a certain value or multiple values from presented in the column to filter data. The options are generated from unique values of the column.

List control can be used to filter by approval status:

List of approval statuses

List of approval statuses

Supported column types:

  • Single line of text
  • Choice
  • Lookup
  • Person or Group
  • Managed Metadata
  • Approval Status

💡 Tip
Do not use List control in case the column has a large number of unique values. It may have a bad effect on UI performance. In this case, use autocomplete control instead of List.

Date

Specific filtering control which can only be applyed to Date and Time column types.

Date filtering control

Date Picker control

Date Range filtering control

Date Range control

Date control allows the filtering column by a specific date or range of date.

💡 Tip
When using the Date Range control, you can specify only the minimum or maximum value. Еhis is equivalent to the "is greater than or equal to" and "is less than or equal to" filters, respectively.

User or Group

User filtering control

User Picker control

User filtering control

User Picker with multiple selection

User or Group control can be used to pick up user-related entities such as User, SharePoint Group or AD Group. The filter returns only the items where the column equals the picker value or one of them in case of multiple selections.

Yes/No

Yes/No filtering control

Yes/No control

Special filtering control to choose one of the options to filter list items or documents:

  • (All). Returns all items.
  • (Blank). Returns only the items where the column does not have a value.
  • Yes. Return only the items where the columns matches "Yes".
  • No. Return only the items where the columns matches "No".

Taxonomy Term

Term Picker control

Term Picker control

Term Picker with multiple selection

Term Picker with multiple selection

Filtering control providing native SharePoint Term Picker to pick up one or many Taxonomy Terms.

Slider

Slider filtering control

Slider control

The slider allows specifying the filter criteria by selecting a value in the range from minimum and maximum of the column values.

Supported column types:

  • Number
  • Currency

Number Range

Number Range filtering control

Number Range control

Number Range control allows filtering Number and Currency columns by specifying minimum and/or maximum values.

💡 Tip
When using the Number Range control, you can specify only the minimum or maximum value. Еhis is equivalent to the "is greater than or equal to" and "is less than or equal to" filters, respectively.

Supported column types:

  • Number
  • Currency

Matrix

Supported SharePoint column types and filtering controls which can be applied for are presented in the matrix:

List Filter Controls and Supported Column Types Matrix

See Also

Share