In the "Save As" box that appears, type in a new name for your view. To create a new view, select the name of the current view, and then choose Save view as from the menu options. You should notice the name of the current view, with an asterisk (*) next to it-indicating that the view is unsaved. Look at the Views menu at the top right of your list or library. Repeat steps 1 and 2 for any other columns you want to filter on.
LIVE TILES SHAREPOINT HOW TO
If you would like to learn more about the filters pane and how to filter by values stored in several different columns, read What is the list and library filters pane? You should now notice that your column header has a filter icon next to it, to indicate that your list is being filtered by values in that column. When you are finished, click the Apply button. In the filter pane which opens on the right side of the page, choose the column value(s) by which you wish to filter the list. Open the List or Library where you want to create a view.Ĭlick on the heading of the column you wish to filter by and choose Filter from the menu options.
For sorting and filtering, you can choose columns that are in the data set, but not displayed.
Before creating a view, you may want to add more columns to the list to enable more flexibility for sorting, grouping, and filtering. For more info, see Add an index to a SharePoint column.Īfter you index a column, you can add it when you create or modify a view, and then use it to filter the view. If the columns that you'll be using to filter don't have indexes, you'll want to start by creating indexes. The second query selects all Mammals, and then filters to Dogs and Cats. You could also search for cats and dogs with the query Class = Mammals AND (Species = DOG OR Species = Cats). However, if you have an indexed column called Class, your query becomes Class = Mammals AND Species = Dog. If you just query for Species = Dog, your query will be throttled. You have an unindexed column called Species where you have Dog as a value. For example, if you want to return Dogs from a large list of animals. If you use two or more columns in the filter expression, the determining index or indexes should use an AND operator. If there are more than 5000 items returned, the query is throttled. However, if you have a query size = large OR color = red, though database may find all the red items, it must scan the complete list to find all the large items. As long as there are fewer than 5000 "red" items in the list, the query succeeds in a large list. In the list, size is not indexed, but color is. The view does not use those indexes, even if the result of the filtered view returns less than the List View Threshold.įor example, you have a query: size = large AND color = red. Other columns you specify in the view filter may or may not be indexed. SharePoint selects the first indexed column in a query, and then uses the rest of the columns to select your data. If your data set doesn't have over 5000 items, it's still a good practice. If you've got 15,000 items, you'll want to have the first index return less than 5000 items. For example, filtering on a state or date field can often reduce a data set considerably. When you create a filtered view, your first indexed column in the filter expression should reduce the data set the greatest amount. Filters reduce the amount of data returned by selecting items based on operations (such as greater than or less than) and matching data.