Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [filter]

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

0
votes
1answer
10 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 ...
21
votes
3answers
13k views

SharePoint 2013 REST expand and filter issue

I've been using REST for a lot of tasks, and with the recently added $batch endpoint, it's more fun than ever. There is one thing bugging me though, and I'd like to share it with you, perhaps someone ...
1
vote
1answer
18 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 ...
12
votes
3answers
16k views

Getting document name using REST (not title) while filtering document library

I am trying to filter through a list and return metadata of the documents in that filter. How do I return the name of a document from a document library using REST while being able to filter the ...
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 ...
1
vote
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
0answers
22 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 '...
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 ...
1
vote
1answer
14 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 ...
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
2answers
730 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
1answer
594 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
0answers
19 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
10 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
1answer
656 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
2answers
677 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
1answer
878 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 ...
0
votes
0answers
14 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 &...
2
votes
0answers
136 views

Issue while filtering multiple columns if one of the fields is Indexed

I have a list in SharePoint 2016 with over 35k items and around 15 custom Fields. I have a view that displays only around 300 - 400 items. When users filter the view using the column filters, the ...
6
votes
2answers
684 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 ...
16
votes
7answers
76k views

REST with $filter for List Items in Sharepoint 2013

Sharepoint 2013, REST API, native C++ application: I want to get all Folder items from the list. Try /_api/Web/Lists(guid'GUID')/Items?$filter=FileSystemObjectType+eq+1 and get HTTP 400 Bed request. ...
1
vote
1answer
662 views

Manipulate Filters in Javascript

Is there any code in JavaScript which allow to manipulate filter to a library webpart?
1
vote
1answer
21 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
3answers
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
1answer
37 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
3
votes
1answer
739 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
704 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, ...
1
vote
1answer
65 views

Creating a true master detail view using Search web parts

The requirements are: Search Result web part 1 shows all master elements ( e.g buildings ) , once a building is selected then Search Result web part 2 should show all equipment in that building. I ...
0
votes
0answers
19 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
1answer
865 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
842 views

Autocomplete Text Filter Webpart

So I have to setup a text filter that is connected to a big list of names. Is it possible to configure some kind of autocomplete on this text filter to help users?
1
vote
1answer
840 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
0answers
88 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
1answer
820 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
0answers
118 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
55 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 ...
0
votes
1answer
27 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
1answer
866 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 ...
1
vote
0answers
24 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
77 views

Filter list without using SPD

I'm trying to filter a list, something like the OOTB WP, but more flexible. The problem with the webpart is that the user has to input the exact contents of the item he wants to find. I would like the ...
0
votes
3answers
842 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
874 views

Query String (URL) Filter Web Part

I am developing a portal in SharePoint 2013 in which I am using Query String URL filter web part, the function of web part is to filter the web parts on the bases of years. I gave the default Year ...
1
vote
2answers
881 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
0answers
68 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 ...
0
votes
1answer
887 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 ...
2
votes
1answer
31 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
7 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
17 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
954 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
1answer
977 views

Filtering SharePoint List columns using a textbox (like filters in MS Excel)

I want to enable search on every column of a SharePoint List. It should work like filtering in Excel. User can type in the textbox and filter that column.