5 ways to filter SharePoint list data

5 Ways to filter SharePoint list Data Filtering SharePoint list data is not quite easy as you think. Different businesses require different filter parameters to get things done appropriately. It is a waste of system resources trying to display all data at every given point in time. The smarter way to do things will be to have specific data displayed based on what is needed at that point in time. It is more productive if our data is defined by parameters like

  • Displaying data which is tied to a unique user
  • Displaying data based on unique dates
  • Display data base on unique texts
  • Displaying data of user in current session

Data preference based on various search criteria is absolutely important if you want to make the best of your intranet solution.

  • In SharePoint there are filter query WebPart that aid precise data filter based on whatever is entered into the search area.SharePoint Query String Filter
  • Select Text filter WebPart and enter the desired text to enable the data filterSharPoint text filter
  • Select Current user filter if you want information about a logged in userSharePoint current user filter
  • Select Date filter if you want search results to be returned by a particular dateSharePoint Date Filter
  • SharePoint list filter helps to further filter the data within a particular listSharePoint List Filter

Configuring these filters

  • Include list and filter on the same page
  • Edit page
  • There is a small downward arrow by the query filter string you added, click on it and select edit webpartSharePoint Edit Filter
  • Enter the following: “Query filter string name”, “Query string parameter name” and If necessary, enter a default valueSharePoint Query String Filter
  • Click on ok
  • Toward the right side of the added list there is small downward arrow, click on it. Hover your mouse on the connections menu, and hover it again over ‘get filter value from’, and click ‘query string filter’. A pop-up will be openedSharePoint query string Popup
  • Ensure that those pop-ups are not obstructing anything on your browser.
  • The 6th step talked of above will open up a pop-up : Contained in the pop-up is a drop down is the consumer field name, select one and also select a field name to which the filter would compare the value toSharePoint Query String Connection Settings
  • Click on ‘finish’

This will link the query string filter you have chosen with SharePoint list. Put the query string in order for you to be able to browse the page. Here is a sample format of the query string.

<>?EmpID=<>

if you desire a wildcard filter, just add ‘*‘ to your search value, like this

<>?EmpID=*<>*

If you have any questions on filtering SharePoint list Data, please add your comments below. We will try to help you out!

Leave a Comment

Do you want us to set up free intranet for SharePoint for you?
WAIT!

I am so confident that you will benefit from the Intranetbee! I would like to present to you a 100% discount off the original price!

Subscribe and get free SharePoint Intranet software right now!
Thanks for your interest on Intranetbee! We will get back to you with installation instructions!