Questions tagged [filter]
A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.
752
questions
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 ...
