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
1answer
2k views

Exclude items from a view using filter

I want to create a view which rules out several items in a list, i.e., if there are options A,B,C,D,E in column X, I'd like it to contain all list items except those that contain options D or E (...
4
votes
1answer
4k views

Filter list in a WebPart by Contains not Equals (adding a wildcard)

If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction for doing it in SP2007 has been provided at Can I Filter a List/Data View using Contains ...
0
votes
2answers
16 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
13 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 ...
1
vote
1answer
307 views

Filter Sharepoint 2013

I have a customer who asked a very difficult requirement and do not know if possible. It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...
2
votes
1answer
3k views

Custom List Filter - update list view only on second button click

What I try to do is making a simple list filter tool for SharePoint 2010 lists. What I have so far: I made a VisualWebPart (VWP) named "ListFilter", which should update the view of the list (see code ...
0
votes
4answers
2k views

Disable column header filter and sorting

I am using SP2013 on-premise. On a list view all the columns' header come with a filter+sorter function. It is not useful on some columns (e.g. photo, which show a picture and no point to sort, and ...
0
votes
2answers
21 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
3answers
3k views

Filter a List View based on data in another list

I'm looking for guidance on how to approach a problem. I have two lists, Goals and Tasks. Goals is a simple custom list with Name and People-Involved. Tasks is a task list with a lookup field to ...
0
votes
2answers
1k views

SharePoint List View Filter by [Me]

Wondering if someone can point me in the right direction please. I have a created a custom list view with a filter on a field called 'User' this is a 'Person or group' field setup to show the 'Name' ...
0
votes
1answer
22 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 ...
1
vote
1answer
595 views

Display connection information within a ITransformableFilterValues web part

I created a filter web part by extending the ITransformableFilterValues interface, similar to this page: MSDN. I want to mimic the Microsoft query string filter and display the connection information ...
0
votes
1answer
30 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
29 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
19 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
1answer
21 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
0answers
12 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 ...
1
vote
2answers
2k views

SharePoint Calendar view with Query String Filter

I need to create two custom columns inside SharePoint Calendar List and I need to apply Filtering to calendar view with regards to custom columns for the users. I need to apply the same using default ...
0
votes
1answer
19 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
20 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
20 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
1answer
26 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
22 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 ...
0
votes
1answer
657 views

Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model

I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript. I've tried everything to get those results with query like: "<Where>" + "<...
1
vote
1answer
1k views

SharePoint 2013 REST API Filter hidden Fields

I have a little Problem. I'm trying to do the following. There is a Field on SharePoint List items called HasUniqueRoleAssignments that is hidden on a standard REST call. If I put it in the select ...
1
vote
1answer
683 views

Manipulate Filters in Javascript

Is there any code in JavaScript which allow to manipulate filter to a library webpart?
7
votes
2answers
738 views

How to fix 5000 Limit for Views but without breaking Alerts

So recently I saw the infamous message about getting close to the 5,000 item limit. After spending a couple of days doing some testing, it seemed like the best option would be to simply Index the ...
1
vote
1answer
26 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 ...
1
vote
1answer
85 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 ...
1
vote
3answers
2k views

Sort and Filter Rich Text

i have a sharepoint list with a few rich text columns but in the view the headlines of these doesnt have the button to sort or filter them like all other non rich text columns have. is there a way to ...
0
votes
1answer
745 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
3
votes
1answer
817 views

Filter sharepoint list using multi line text field

I'm trying to filter a sharepoint list using ajax api. So one of the filtered field is Multi line text field (FieldType.Note) , after performing request it throws an error telleing that the field ...
1
vote
1answer
68 views

Problem with date range filter

I have implemented date range filter on my SharePoint 2016 list using date filter web part. The complete procedure you can find here But after this implementation my list search box vanished. Even ...
1
vote
1answer
610 views

Datetime format when using $filter in ListData.svc

I'm using ListData.svc to retrieve items from a SharePoint 2013 calendar list. I have two jquery ui datepickers to select the date range. Values are read with the following: var s = moment(jQuery('....
0
votes
1answer
886 views

Filtering list view based on querystring using jQuery?

Using Sharepoint 2010 Content Editor Web Parts (some links dynamically created) List View Web Part Ability to add additional software or packages to the system extremely limited (so would prefer ...
5
votes
3answers
11k views

Textual resolution of [Current User] and [Me]

In a list-view filter, I think I want to use either [Me] or [Current User]. I can't find a list of possible filter variables with their possible resolutions anywhere (Sharepoint Server 2010). What ...
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
36 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
885 views

Sharepoint 2013 - Search files into File Share (content source) with filtering by folders

I crawled content that is on stored on file server (File Share - content source in SharePoint Server) and i get the results in SharePoint search. Everything is fine but i need to have some kind of ...
0
votes
1answer
55 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 ...
3
votes
2answers
3k views

Can I filter a SharePoint Calendar? Is such a thing possible?

It strange that for something that sounds so simple and common, it is most likely impossible. When I first approached this request I never thought I'd end up here typing out my problem ... I added a ...
0
votes
1answer
18 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. ...
1
vote
1answer
324 views

Order of choices in filter drop-down

In a list, at the filter drop-down section, choices are in ascending order: Is it possible to display the choices in descending order? (It would be more comfortable because users usually choose the ...
1
vote
1answer
886 views

Passing employee id from AD to a SharePoint list

I have a property named EmployeeId in AD. UPS is configured and is getting all users EmployeeID from AD. I have made an external list. I want to pass logged in user's EmployeeID to that list so it ...
0
votes
1answer
13 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
1answer
920 views

Issues with SPFilterDropdown in SPD2013

To start things, I have little knowledge beyond the basic concepts of SPD and being a newbie... What I want to accomplish is to only have certain values from another list show up in which their ...
0
votes
3answers
862 views

Document Library Not Filtering Columns

There is a document library which has over 5000 items, it has passed its item view threshold. The view was reduced to show items that met certain requirements. This view now shows less than 1000 ...
1
vote
1answer
1k views

Have a webpart in a Page layout get filter value from column value

I'm new with SharePoint but I feel like I'm catching on pretty well. I'm creating a new page layout and I plan to put a list webpart in the right column. The list webpart will be filtered using the ...
1
vote
2answers
938 views

Update InfoPath form field value in SharePoint Online document library?

I have saved InfoPath Form in a Form Library & also saved field values in separate columns, now I have retrieved one record in InfoPath Form 2013. I'm trying to update Status columns value from ...