Questions tagged [filter]

A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.

Filter by
Sorted by
Tagged with
0
votes
2answers
37 views

Filter a Library and multiple Lists on a Page based on the same column (date)

In classic mode a List Filter Web Part is available but what to do in a modern site. Is it still possible to use a classic page in a modern site with the List Filter Web Part? If yes how if no, is ...
0
votes
1answer
23 views

'Select All' option in SharePoint 2013 list column filters

I have SharePoint 2013 list. Need to get 'Select All' option in list filter (on the columns' filters). Currently SP only has 'Clear Filters'. The feauture I need is the same as in Excel Autofilter: ...
0
votes
0answers
24 views

Trying to filter a list based on right now

I'm trying to filter a simple Employee Sign Out list in SharePoint 2013. I have a column for departing (date/time) and returning (date/time) and want to filter so that only the people that have ...
0
votes
2answers
30 views

In SPO list why would FilterFieldX/FilterValueX work while FilterName/FilterMultiValue is ignored?

I am using a custom list with standard OOB AllItems.aspx view using the modern experience. (NOT a web-part, NOT the classic experience) When I filter using .../AllItems.aspx?FilterField1=...
0
votes
0answers
25 views

Filtering a list by input date between 'start date

I have a MeetingTopic list (things to discuss at a meeting), with a StartDate field and an EndDate field. I am trying to create a page that takes a date parameter (MeetingDate) and presents all topics ...
0
votes
2answers
32 views

SharePoint CSOM list group by and filter

I have a list with columns "fruit" and "ripeness". Using csom, how can I return "Banana" where Yellow count >= 3? ClientContext ctx = new ClientContext("https://sharepoint.blah.com"); List list = ctx....
0
votes
1answer
31 views

How can I filter a library using multiple columns?

I'm trying to filter a library using multiple columns, by project number, type, and an additional category, however when I use multiple filters, the filters applied last don't apply properly. For ...
1
vote
0answers
31 views

Filter for noobs [closed]

I'm trying to learn about filters in SharePoint. A colleague tried to setup alerts for his tasks. He made a view filtering all of his tasks out of his departments tasks and then created an alarm about ...
1
vote
1answer
21 views

current user filter web part in SharePoint

I would like the user to only see their tasks that are meant to their department for example (IT Users when they are logged into to Tasks list ) they should only see Tasks for IT department only. I ...
0
votes
0answers
13 views

how can i filter a list in a view on a page without breaking pagination?

I have an app part placed on a page in which i want to filter the data in the list to show. The data needs to be filtered by multiple conditions. i have most of the filtering done, but filtering by ...
0
votes
1answer
29 views

How To Apply filter to List View Web Part based on content of Data View field

I am building a project management tool. the top of each project page shows a List View webpart which displays information about the project's current status. A second List View displays a Task List ...
0
votes
1answer
22 views

Use image icons to filter library view web part

We are on SharePoint O365. I have created a wiki page on a classic page setup. On that page I have placed several .gif images and the library view web part. What I'd like to do is filter the ...
1
vote
2answers
21 views

List “filters pane” works fine for text STARTING WITH. But how to filter on text that CONTAIN words?

In Sharepoint 365 I created a list and by default you can filter with the filter pane. For instant I have a company colum and a company name in ABC International. I want to filter for all compies with ...
0
votes
1answer
24 views

document-set filters?

I have a library with multiple document sets, each of which has custom metadata. I want to create a filter for use within doc-set A that filters on A's custom metadata, and a filter for use within doc-...
0
votes
2answers
35 views

Custom List Header Column Sort/Filter

I'm trying to re-format the sort/filter drop down box on the column header of a custom list (font-family, font-size, background etc). This appears to be possible by using the following rule in a ...
1
vote
2answers
21 views

How to filter out this?

Im a beginner.. I have searched now for some hours for a solution without success. I have following list with 3 columns and 3 items Date Id Place 190725 1 A 190724 1 B ...
0
votes
0answers
27 views

Odd Behavior for Rest API lookup Column filtering

I've recently been working on a project requiring Rest Queries against a large SharePoint list (5000+ items) and ran into an interaction I can't quite find an explanation for. The scenario is that I ...
1
vote
1answer
30 views

Disable Filter on Individual Column Headers of Custom List

I'm working with SharePoint 2013 and my Company don't allow the use of SharePoint Designer. I have created a custom list and am looking to disable the column header filter from a number of the ...
0
votes
0answers
19 views

SharePoint Refinement Filter Display One Column and Sort by Another Column

I have a refinement webpart on a search page with several refiners. The issue I am having is that I need to sort the refinement filters based on another column or some other way to perform a custom ...
1
vote
1answer
79 views

Is it possible to filter search results when searching in a modern document library?

I noticed that when I search for something in a document library and click "See All" for all the search results, the filter icon in the top right corner disappears and I am unable to use any of the ...
0
votes
1answer
25 views

Possible to get tasks based on a local custom field value using Project Server JSOM?

I have been working on a web part that lives on a SharePoint site in a Project Web App instance, and interacts with Project Server using the Project REST API. I need to be able to get tasks based on ...
0
votes
1answer
87 views

Customize Filter Icon and filter pane in a Modern Experience document library

I am learning that the modern experience of SharePoint Online does not leave much room for customization. I had a request from the line of business to make the filter ICON considerably more visible ...
0
votes
1answer
20 views

Filter Event Calendar by Column

I have a SharePoint calendar that I have added a drop down column called SalesAgent, which contain Sales Agent names that is selected when event created. Each agent has numerous events on a calendar. ...
0
votes
1answer
14 views

Creat a view with Sharepoint List: Sort by column then filter everything but the most recent

I have a list coming in from forms with a serial number and a date: [Serial Number] [date] a-6/10/19 a-6/12/12 a-2/4/14 b-3/2/15 b-4/1/12 I want to create a view where I only display the most recent ...
1
vote
0answers
15 views

Page filter doesn't work in edit mode

In my library I have the document id service turned on. So each new document gets an unchanging id. That is working. I then have some other documents which are related to a given page. I've created a ...
0
votes
2answers
42 views

Exporting a list to csv from a custom page

I have a custom page created to allow users to be able to select their own parameters to filter items in a list using web-parts (with help from SharePoint designer 2013). This filtered list needs to ...
0
votes
2answers
22 views

Turn Title bar filters on at all time

We have a number of custom lists, and on some of the larger ones the sidebar popping up is undesirable. We added Filter=1 to the links to the lists which turns on the filters at the top, which is ...
0
votes
0answers
11 views

Losing CQWP filter “Contains all of” when applied/saved

I've added a CQWP to a web part page. In the web part properties, the source is from a single list, and i'm trying to add additional filters. If the second or third additional filter is set to "...
0
votes
1answer
40 views

Please tell, can we filter data on SharePoint Hyperlink Description but not URL using sharepoint query [closed]

Please tell is there any way or workaround we can filter on hyperlink "Description" using sharepoint query. I know we can filter listview rendering using JSlink and hide rows but problem is when user ...
2
votes
1answer
39 views

Sharepoint large list filtering

Currently in Sharepiont 2010. I have a list that just went over 5000 items. I have columns indexed and all views are filtered with these indexed columns. One of the columns is a "Date and Time" type ...
0
votes
1answer
22 views

View showing new list items

Is there a view (or a way) that show new items only to a list? My goal is to have a "New Items" list, or view that will be updated automatically shows any thing within the past 24 hours. Filtered ...
1
vote
1answer
49 views

Is there a limit of conditions count for oData query using $filter?

I have a long $filter query like ID eq 1 or ID eq 2 or ID eq 33 or ID eq ... and it works like a charm when we have up to 159 conditions joined by or. But, when I add one more condition (started from ...
0
votes
0answers
31 views

SharePoint - Infopath - Lookup Field - Filtering Out Items

I'm working with a SharePoint List (we'll call it List A) that has a lookup field to a second list (List B). List B has two fields: REPORT_NAME & RETIRED. RETIRED will either be blank or have an '...
1
vote
1answer
19 views

Items that SHOULD be showing in a view, aren't

So, I have a large list, with ~10,000 items. I have created several views that filter via indexed columns that show below the threshold amount. But I just modified one of the views, (changed the ...
0
votes
0answers
26 views

Filter Secondary data source based on two filter values - Infopath

I have fields 'Project Description' and 'Stage' in my secondary data source and also 'ProjDesc' field in my main data connection. I am trying to filter my secondary data source when 'ProjDesc = ...
0
votes
0answers
19 views

Filter not working in List created from template

We use a list template to create new Lists in our SharePoint 2013 environment. Everything works, but when we try to filter 2 values from one column all elements are displayed again (see screenshots). ...
0
votes
0answers
20 views

Filtering a List View with multiple conditions

I have a view I am editing in SP Designer 2013 and I keep getting a "Cannot complete this action. Please try again.Correlation ID:d47ecb9e-10f2-a0dd-4e30-aaddb657494b" error. My desired filter: (a &...
1
vote
1answer
56 views

Unable to filter multiple columns of “Person or Group”

I am trying to create a view for our agents so that they can see if they created an item or if they have been added to an item. To do this I thought it would be as simple as: Agent Name (Indexed) is ...
0
votes
1answer
102 views

Filter list view by current year on SharePoint Online

I have a year column in one of the SharePoint list. I want to create a view to filter the items by current year. How to do this? I have tried a lot but it doesnt work. Please help
0
votes
0answers
88 views

Filter File types from Folders/Files

I am able to pull in the data I need with using part of this sEndPoint Main folder I'm pulling from: https://company.sharepoint/sites/Site/_api/Web/GetFolderByServerRelativeUrl('Folder Name')? ...
0
votes
0answers
93 views

Filtering view and workflows for lookup columns

I have 2 lists with the following columns: List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)" List B - "StatusNameReq"(Lookupcolumn based on the columns in List A) Now, I want to ...
0
votes
0answers
310 views

Quick Chart Web Part - Data From SharePoint List Confusion

In SharePoint Online, I can't seem to get my quick charts to work or display the data I would like. The Column that has data to display option seems to just grab columns with numerical values. Is ...
0
votes
1answer
122 views

CAML filtered list views - filter more than one nested level?

do you know if it's possible with CAML to write a SharePoint list view filter query to retrieve a user that is a member of a group which in turn is a member of another group i.e. nested groups? I've ...
1
vote
1answer
107 views

How can I filter the Highlighted content web part to only show things that the user flagged as “Save for later”?

Seems like it should be pretty straight forward however I am not seeing it. There is already a baked in feature where people can tag a page or document "Save for later" at the bottom of most pages ...
0
votes
1answer
79 views

Search SiteGroups API not working when case sensitive

I'm using the API to search for sitegroups as below: "/_api/web/SiteGroups?$orderby 'Title'&$select=Id,Title,LoginName" + skiptop + "&$filter=startswith(Title,'" + value + "')" However, I ...
1
vote
0answers
91 views

How to filter on a Edm.Double type using rest api?

I'm currently working on a small project where I need to query the Access Request list of a site, while this list is sort of hidden the REST api works perfectly (Mind you the title might be different ...
2
votes
1answer
57 views

SP2013 Custom List - Case Sensitive Filter with JQuery

Good Morning Friends; I am using a JQuery script to act as a filter on a custom list. The text in my custom list is all Uppercase. Currently the filter is case sensitive. I tried using text-...
0
votes
0answers
10 views

“Shaded” Custom List View Class?

Good Afternoon; I am using JQuery to filter a Contact List. The code I am using is attached below. This code works with the default view, however does not work with Shaded View. Does anyone know ...
1
vote
0answers
19 views

Want Filter fetch data from SharePoint lIst on the below code of autocomplete JS

where DocumentOwner(People Group Type Column) = Me (Current Logged in User) Here i save current logged in user in a variable named as OwnerTitle and RequestStatus(Choice Type Filed) is equals to ...
1
vote
1answer
174 views

Get field value from form and pass to web part list view filter

In SharePoint 2016, I have created an edit form with a web part in the footer area that displays list data. I would like to grab the value from the field named Start Day and then use that value to ...