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

Create a view Filter SharePoint list for items I - [Me] - haven't rated

Is there a way to filter (and subsequently create a view for) a SharePoint list to show items that the current user hasn't rated? For example, in the list below I would like to create a view that ...
0
votes
2answers
25 views

Pass parameters to external list on SP2019 Standard

I have an external list that is displaying data from a SQL Server view. Now, I want to add filtering. The problem is that I'm working on Standard version of Sharepoint, so no Enterprise webparts are ...
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 ...
1
vote
2answers
2k 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 ...
0
votes
4answers
942 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
718 views

Manipulate Filters in Javascript

Is there any code in JavaScript which allow to manipulate filter to a library webpart?
0
votes
1answer
835 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, ...
0
votes
1answer
40 views

Filtering listview using React Sharepoint

I am trying to display data in react-data-table-component according to the input given in the search field using Rest API. For eg: If a user enters name of the person the react-data-table-component ...
0
votes
2answers
788 views

filter ListView using RestApi in sharepoint APP

Please let me know is there any way to filter list inside listview using restapi Example: TestList And below is my custom search:(currently it is configured on Title field) Now after filter(Title=...
3
votes
1answer
1k 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
871 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 ...
1
vote
1answer
18 views

Filter data based on Taxonomy value [closed]

I am building a search web part in which, I am filtering the data from the SharePoint document library based on the value in the skillset column. It is a managed metadata column. Below is the ...
0
votes
1answer
960 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 ...
1
vote
1answer
982 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
17 views

Filter list by Author (Created By) field with rest api - SP Online 2019

So I'm sending a REST query like: _api/web/lists/GetByTitle('List')/getitems?$select=AuthorId It works fine, I see 49 records with AuthorId. Now I want to filter by this column. Then I want to filter ...
2
votes
1answer
879 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
1answer
1k 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
2answers
10 views

Add multiple Fields For the CamlQuery in Sharepoint Hosted App

I am trying to filter two fields or more that is clean of null values. It works for the first field but it is not working for the second field: <View><Query><Where><IsNotNull>&...
1
vote
1answer
1k 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
1k 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 ...
0
votes
0answers
24 views

Multiple input filtering on SharePoint calendar listview using Javascript

I am trying to use the code below generously provided by @Cat in this post; https://stackoverflow.com/questions/63093757/javascript-filtering-by-multiple-columns, to filter a sharepoint listview. Any ...
0
votes
1answer
16 views

All columns not present in create view filter option

Trying to create a view which filters a specific columns with hyperlinks in it. I went to create view --> filter and that column does not appear in the drop down. Any ideas?
2
votes
2answers
37 views

(another take on) Filtering Sharepoint view based on date range

I know that the answer for this question is easy to find on the internet, including this thread - but the suggested solution doesn't work for me. I need to create a view in a Sharepoint online list, ...
0
votes
1answer
1k views

How to Connect a list from another Sharepoint Web Application

How Could I connect a SharePoint another list which is situated in another web application? A mast get another list from another web application, and give a filter to show only this elements, which ...
0
votes
1answer
26 views

Tagging news and filter them afterwards

Currently I´m trying to figure out whether is it possible to tag my news with a # or something else and then to create a news feed where every user can filter individualy by them self the news ...
1
vote
1answer
54 views

Sharepoint online — managed metadata term set filter not working

Novice user here. We have created a list of products on sharepoint online. Products are tagged using a managed metadata term set. We would like to use this to either A) filter the list and save views ...
0
votes
1answer
68 views

Querying a sharepoint list with more than 5000 records returned while supporting sorting and filtering

We are facing some problems dealing with large list on SharePoint online via API, we tried below methods but no luck, please advise if there is a proper way to handle such cases. Requirements ...
0
votes
1answer
1k views

Filter SharePoint lists by a Person or People Picker

How can I create a web part page, where the search web part is a "peoplepicker" like control which then filters 3 SharePoint lists below it on the "CreatedBy" column. Scenario: Find all entries made ...
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 (?...
5
votes
2answers
3k 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....
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
2answers
5k 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' ...
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 ...
0
votes
0answers
37 views

Filter expanded properties with the REST API

I am trying to query a folder recursively for files that were created after a certain date. I am able to find the files by expanding file properties however I am unable to filter against the expanded ...
0
votes
1answer
32 views

SharePoint Online 'Filter By' not showing all available options

I have created a custom list which contains around 32,000 items. There is a 4 part key which looks something like 'T1-0000-X-XX'. Each part has a meaning. In order for users to be able to filter by ...
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
18 views

SharePoint List View Complex Filter Logic

I'm creating a SP list view and trying to apply a filter to it without creating calculating columns to compare: Show items only when the following is true: Status equals to "Cancelled" AND ...
0
votes
1answer
3k 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 (...
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
855 views

Filter by “Created by” is not working

I have created a list view that filters documents on "Created by" column. Users within my organization are able to see the information correctly. However, users who are logging via external account(...
0
votes
0answers
25 views

Using Query Filter (URL) String with Images

I have a page with a document library & a task list using query URL filter strings. Is there a way to filter images stored in a site assets library? I would like an image on the page to change ...
0
votes
1answer
39 views

Sharepoint REST API - Filter by Negative Number

I'm trying to filter by a negative number but it only seems to work with zero or positive. Does anyone know how to fix this? My query is below: spUrl + '/SitePages/checklist.aspx?filter=ChecklistID/...
11
votes
3answers
16k views

Show folders in document library that have a filter view

I am using SharePoint 2010 I have a document library with a view that Filter items only when a particular Column is true. The problem now is that when I have a filter in my view the folders in my ...
1
vote
1answer
135 views

View only Folder items

Can someone explain to me why this is not working (and how to make it work)?: Steps to reproduce : Go to a folder in all document view > edit current view > click show items only when the ...
0
votes
0answers
56 views

JSON list formatting to show/hide items based on SharePoint group membership

Hoping someone can confirm something for me. Here is the scenario: I have a SharePoint list with a 'Managers' column (type: Person/Group). I have created a SharePoint group called 'Managers SP Group'. ...
18
votes
1answer
72k views

Rest API - $filter multiple values

Assuming there is a list of Students each with a zip-code, how can I get records for multiple (but not all) zip-codes. When using $filter how do specify multiple values? Here's what I have so far: ...
0
votes
2answers
188 views

Filter a list by User or Group column in CAML Query

Is there a way to filter a list by User or Group column? I need to get all the tasks assigned to each user in a site. I got the below code for now, but that only works if I'm trying to get my tasks. ...
3
votes
1answer
82 views

Link Document Library to Search Filter

I have a SharePoint Content site which also has a document library. The document library has columns that classify the document. I am trying to (on the homepage of the content site) add a Search ...

1
2 3 4 5
17