Displaying Data | SharePoint Designer Tutorial: Working with SharePoint Websites

Filtering Data

It is possible to filter our data view so that only certain records are displayed. We will use this functionality to display only products with a price of over $15. This feature works in a similar manner to the conditional formatting (albeit there is no formatting to be applied). To filter our data view, we follow these steps:

Right-click on our data view.
Select Show Common Control Tasks.
Select Filter: from the list.
Click on the first row to add our new clause.
Specify the following values:
- a. Field Name = Price (Number)
- b. Comparison = Greater Than
- c. Value = 15
Click OK.

You will notice that our data view now only displays the products that are priced over $15.

To remove the filtering, we follow the first three steps so that the Filter Criteria dialog appears again. We remove our criteria by right-clicking on the black arrow to the left of the criteria and selecting Remove. Finally, we click OK.

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

SharePoint Designer Tutorial: Working with SharePoint Websites

By : Mike Poole

SharePoint Designer Tutorial: Working with SharePoint Websites

By: Mike Poole

Overview of this book

Filtering Data

SharePoint Designer Tutorial: Working with SharePoint Websites

By : Mike Poole

SharePoint Designer Tutorial: Working with SharePoint Websites

By: Mike Poole

Overview of this book

Filtering Data

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access