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
19 views

SharePoint List Filter - Apply Filters button

In SharePoint Online, I have a web part page in which I have different SharePoint List Filters allowing to filter List Web Parts. I am facing issues regarding the Apply Filters button, especially with ...
0
votes
1answer
28 views

Metadata Navigation and column filtering

We have a document library with metadata navigation enabled. Some columns in the library are eligible column types for metadata navigation and others aren't. The column filtering via the column ...
3
votes
2answers
1k views

Why doesn't FilterOp work with Inplview?

I am trying to pass a URL into a SharePoint listview with parameters for filtering. The FilterOp paramter doesn't work with inplview for me. If I pass the parameters in normal query string format (?...
0
votes
2answers
2k 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' ...
5
votes
2answers
2k views

How to create SPQuery by filtering date interval

I have a custom aspx form where I retrieve list items by filtering two values EventDate and EndDate. I have a realization but it returns nothing: DateTime eventDate = Convert.ToDateTime(properties....
1
vote
1answer
27 views

Multiple $filter in OData query

Here is my OData query: https://XXX.sharepoint.com/sites/pwa/_api/ProjectServer/Projects?$filter=Id eq guid'xxxx'&$select=Id,Name,StartDate&$expand=Tasks&$select=Tasks/Id,Tasks/Name I ...
0
votes
0answers
17 views

Custom Filter by single column

I am currently using the below code for a jquery filter on a custom list. Is it possible to narrow this code, so it only searches on <script type="text/javascript"> jQuery(document).ready(...
1
vote
1answer
311 views

Cascading SharePoint List Filter

I have a list in my sharepoint site that has two columns I want to filter by on a webpage. I want to have the first sharepoint list filter webpart to have the person select a Project Manager. Than I ...
5
votes
3answers
2k views

Remember filter value using jquery and cookies

I am looking for a solution for the following problem: I have a large list that is related to a second list. The two list web parts are on one page, when you select an item in the first list, the ...
0
votes
1answer
22 views

News feed SP Online

Is it possible to grabs news from different site? If I select news source: this site, everything is working fine and I have all the needed filters but as soon as I change to different news source: ...
24
votes
4answers
27k views

REST API OData Filter on Boolean not Working

When I perform a REST query to the following URL: _api/web/lists/getbytitle('BtProjects')/items?$filter=Active eq true I receive only the one item that has this field marked as false. I get the same ...
0
votes
1answer
47 views

SPO: Show Autocomplete Filter WP results as Title field values but filtering from another field's value [closed]

I am using an autocomplete filter customized in the HTML Form WP. When a user begins typing the name of a Company (i.e. Title field from the Companies list), all matching results autopopulate as the ...
1
vote
2answers
1k views

Cannot filter in quick edit in Sharepoint 2013

I have a list which have a lot of data. I can filter list in standard view but when I use quick edit view, just some column can filtered. It's not display "show filter choice" when the column have too ...
1
vote
1answer
25 views

Filter pane bug in modern experience when using a calcuated column

I've run into an odd bug when using the filter pane to filter a calculated column in SharePoint 2019 on premise. When using the see all option, the "8_" text is added to the filter value and the ...
-1
votes
2answers
49 views

Filter choice column with distinct value in powerapps

I want to get distinct value in PowerApps where Active (choice column)="Yes", trying below but I am not getting correct value it returns false value: Distinct(Filter(Splist, Active =true),'...
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
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 (...
8
votes
6answers
20k views

Checked null with dateTime in REST API SharePoint

I want to get all article pages which Article Date is not null. so I have try to do by this way. var ArticlePageContentTypeID = "...
0
votes
1answer
663 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>" + "<...
0
votes
1answer
21 views

Remove pin icon from filters pane

Is it possible to hide or remove the pin icon from filters pane which would prevent users to click on it or remove the pinned column from the filter pane by any chance? Such as making it default ...
0
votes
3answers
4k 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 ...
1
vote
1answer
596 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 ...
1
vote
2answers
3k 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
15 views

In Power App How to filter created by Me and Status

I had written below formula to get item created by me but how to add one more filter of status = Draft Filter(test,Lower('Created By'.Email)=Lower(CurrentUser))
0
votes
3answers
29 views

Search Result by filter does not find an existing and crawled document

This is related to SP 2013 On-Premises. We have a custom Search Page and we use Keyword-Query to filter the Result. The related document which cannot be found by that page has at least two meta data ...
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
2answers
1k 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 ...
1
vote
2answers
237 views

SharePoint list to show all items, with the exception of closed/completed items that are older than a specific amount of time (e.g. 7 days)?

I am familiar with filtering the list to only show current items (not closed/completed), but is there a way to show all items except any that have been placed in closed/completed status more than 7 ...
0
votes
2answers
15 views

Filtering the calendar items base on checkbox

I have a SharePoint calendar for activities which users choose in a column (Choice) what platform is that activity IE. Windows, Unix, Network and so on. Is there a way to filter this using a check ...
1
vote
1answer
696 views

Manipulate Filters in Javascript

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

Sharepoint limit lookup dropdown entries by “pre-filter”

Following scenario: List A contains several thousand items, List B has a lookup-column to List A. When a user is creating item in List B he has to select the List A item via the mentioned lookup-...
0
votes
1answer
18 views

Filter view for column for each indivual in list

How do I filter the view for each user in a list group? So that only the individual user can view there inputted column like SS?
1
vote
2answers
161 views

Dynamically filter documents inside a document library using their folders and sub-folders

I am trying to find the best approach to follow, to implement this business need:- 1- We need to create a document library inside our sharepoint online site collections. 2- the ability to search and ...
1
vote
1answer
24 views

Force SharePoint list filters to display alphabetically?

Does anyone know of a way for force the top five filters for each column of a list (before you click See All) to display alphabetically?
1
vote
1answer
47 views

Is there a way to have a single Metadata Navigation which work on multiple documents libraries which share the same site columns

I am working on an online modern team site collection. and we have 5 documents libraries, where these document libraries share the same 3 managed metadata site columns. Now for each document library, ...
0
votes
1answer
784 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
871 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 ...
0
votes
1answer
20 views

Saving views after applying filter to column

I am attempting to create filtered views to share with pertinent staff. I imported an Excel data sheet to create my list. And, up until now I have been able to achieve my desired end. Until ...
1
vote
1answer
630 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
682 views

How to create a html form webpart filter for 2 list columns

I have a html form webpart (in the form of textbox input). I would like to filter 2 list columns using the same webpart: So instead of the usual filtering for 1 list column, this webpart will be used ...
0
votes
1answer
915 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 ...
0
votes
1answer
27 views

How to filter a list using Button in Sharepoint Designer 2013

I have added a column as category in Announcement list and I want to filter the announcement based on category. I have created no of buttons for the category. I created parameter as Param1 to filter. ...
0
votes
1answer
935 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
11 views

Save filtered view not working

I created an Item list with column headers imported from a table created in Excel. I notice that when i try to sort (Ascend/Descend, etc) the column says, "This column type cannot be sorted." Why is ...
2
votes
2answers
3k views

Turn filter on by default on a sharepoint view

I would like to filter a column defaultly on my SharePoint view, is it possible to do so ?
1
vote
1answer
918 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
3answers
893 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
959 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
1answer
701 views

Empty Filter Option display even no empty value exist

Empty Filter Option is showing in Person or Group column even when there is no empty value existing in the column. Is it normal behaviour?
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 ...