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.

38
votes
6answers
92k views

How to make a filtered lookup field

I have a list of departments. This list will change over time adding new departments and "deactivating" others (because of structural changes). I would like to use this list as a look-up for other ...
24
votes
3answers
24k 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 ...
23
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 ...
17
votes
7answers
78k 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. ...
16
votes
3answers
885 views

Page Layout html page field filter outside of web part zone

I have a page layout with some web parts outside of a webpart zone so that they are added to already created pages which use the page layout. I want to add a page field filter to the page as well ...
14
votes
1answer
49k 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: ...
14
votes
3answers
13k views

Paging and sorting with BCS

I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
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 ...
12
votes
2answers
34k views

Querying a simple list with a 'User' column, using CAML

I'm having some trouble getting a CAML Query working against a very simple list. My custom list has the fields: Person : User Date : Date Amount : Lookup My query looks like this: <Query> &...
12
votes
2answers
3k views

Filter by calculated column with rest api in Sharepoint 2013?

Apparently you can't filter by calculated column with SharePoint 2013 REST API? The calculated column in question returns a string. http://site/_api/web/lists/getbytitle('TestList')/items?$filter=...
11
votes
3answers
16k views

Sharepoint Designer 2013, XSLT List View Options ribbon option is not showing

So I'm wondering if this is a bug or not. I have an ordinary Wiki Page, also tried making an Article Page. Once this page is made, I add an XsltListViewWebPart that points to a list, which is fine, ...
11
votes
3answers
14k 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 ...
11
votes
4answers
11k views

Filters on a large list exceeding throttle limit

On a SharePoint 2010 Server installation, I have a list with more than 5000 items. I created an indexed column and a view based on this column which is returning 100 items only, so far less than the ...
8
votes
4answers
10k views

Filter view by current year

I have a Year column and I already know that it's not possible to filter a view using Year equals =YEAR([TODAY]) and use [TODAY] in calculated columns does not work as expected. Does there exist a ...
8
votes
2answers
51k views

How can I filter a SharePoint list based on a date column?

I have a column with "start date". I also have a column called "expire date". How can I make a filtered list so that it only shows items where the "start date" is equal or greater and equal or ...
7
votes
5answers
18k 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 = "...
7
votes
3answers
17k views

How does SharePoint handle AND / OR view filtering?

Premise: For the example let's suppose I want to create a view that displays Pending items but filters out the Rejected. Since there are multiple approvers, both Col A and B must be used. When ...
7
votes
1answer
4k views

How to filter the timeline

I was just wondering if there is a way to filter the timeline web part, so that it does not show completed tasks for instance? I have tried adding a filter to the task list that the timeline belongs ...
6
votes
4answers
496 views

Filter Created in SP REST API

I have this code below: jQuery.ajax({ url: res3 + "/_api/web/lists('" + normlistid + "')/items('" + normid +"')?$select=ID,Title,Created,QuemLeu/Id&$expand=QuemLeu", method: ...
6
votes
5answers
13k views

How can I filter a view using a blank multi-line field?

I have a multi-line text field and need to be able to show a view with only items where that field is blank (or functionally blank to a human looking at it). I've tried: field contains "" field ...
6
votes
2answers
189 views

List View Threshold questions

I've done tons of reading on the list view threshold and ways to work around it but I haven't been able to answer a couple questions or ultimately find a good way to deal with it in my situation. ...
6
votes
2answers
11k views

Filter People and Group column using [Me]

Our list has a people and group column (called Users) which we want to filter using [Me]. It works when the field only contains individual users, but when the field contains a group (either SP group ...
6
votes
2answers
706 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 ...
5
votes
5answers
52k views

Filter a list view using URL parameters

I would like to dynamically construct a couple of URLs for our SharePoint users to filter down a rather large list view we have. Rather than create a bunch of different custom views, I was wondering ...
5
votes
2answers
7k views

SharePoint Online - Filter Category missing when adding web parts

When I am trying to add web parts(filter category) in SharePoint Online 2013 I did not find the filter category. I have searched about this and activated SharePoint Server Enterprise Site Features but ...
5
votes
5answers
16k views

Why are documents inside a folder not showing when a filter is applied?

I added a custom column called Project (string) to a Document List. I then set different views in different pages to filter on that column. The problem is that, when applying the filter, documents ...
5
votes
1answer
753 views

Only show Sorting option not filtering opetion in contex menu of header in ListViewByQuery

I have creatd ListViewByQuery control through coding and added the control through RencerControl Event. I am filtering the list in code. so filtered result is shown. I want to hide filter context ...
5
votes
3answers
10k views

Page a list via A-Z

So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it. So I was thinking use ...
5
votes
2answers
9k views

List View Filtering on Managed Metadata Fields issue

Our client asked us to change list view filtering to not show all terms from taxonomy in managed metadata, but only those from documents in library. Currently we have two columns: We have a managed ...
5
votes
1answer
10k views

Can we pass null in $filterby in REST query SharePoint?

I am trying to get data from SharePoint list using REST query and filter on some column having null values. But It can't return desired items.. http://<Server>/_api/web/Lists(guid'2B3BD6CD-...
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 ...
5
votes
1answer
974 views

Sharepoint 2010, Document Library, Key Filter - “Modified” field filtering is out by one day

We have a Sharepoint 2010 farm across 4 servers and added "modfied" as a Key Filter for metadata navigation. When I select to filter on a specific day I enter a date the filtered results are out by ...
5
votes
1answer
1k views

Use Term Store as a Filter Webpart

I have a couple of libraries that share a term store field for Clients. I put two list views on a page and planned on using the term store navigator to filter the lists, but couldn't find it in the ...
5
votes
3answers
13k views

Filter a Multiple Selection List Box in Sharepoint

I have what I thought a simple problem, but can't seem to find any solutions that work or exist in SharePoint 2013. I have a multiple selection list box in an InfoPath 2010 form. This box defines the ...
5
votes
1answer
9k views

Use one filter for multiple sharepoint lists

Can I define one list filter, and connect it to two lists on one web part page? I have two seperate lists on a page, both containing the 'author' column. Now, I want to add a filter to de page, so you ...
5
votes
1answer
8k views

Can I Filter a List/Data View using Contains instead of equals in SP2010?

I have a page where I am using a Text Filter to filter a long (15K) list of clients in a Business Data List web part. The filter works fine for All and for an entered name, so long as the full name is ...
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 ...
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....
4
votes
1answer
37k views

View filter settings: how to implement [TODAY] - 6 months

I am building a SharePoint 2013 portal. I have a custom list. On this list I try to modify the default view. I would like to change the filter settings. I would like to show only the items between ...
4
votes
4answers
16k views

REST service $filter Date column

Using the REST services, I'm trying to filter by the Created column, which is a Date data type. When trying to $filter on that column, I passed in the same date format that comes back in the JSON ...
4
votes
2answers
5k views

Library view with subtree taxonomy filter

Let's say I have a following taxonomy tree: World |--Germany |    |-Frankfurt |    |-Berlin |--France      |-Paris    &...
4
votes
3answers
4k views

How can create a view to filter the a list based on the current login user

How to create a view based on the current user is in a Person or Group field , this Person or Group field can contain multiple user but not SharePoint Group ,I try to use the contains to filter the ...
4
votes
1answer
596 views

Is Possible to make filter on calculated column??

I have Date column in list on based it i have create two calculated column month and year. Now i am trying to get data for particular month and year so I have give filter in REST query but it give ...
4
votes
1answer
6k views

“Show filter choices” link instead of actual values in a list column filter

I have created an standard list with a few simple text columns. Why can I not see the normal filter values of all columns? Instead it shows a new "Show Filter choices" link (pic 1) which when ...
4
votes
2answers
2k views

filtering rest api call by calculated column

I am not getting any results when I try to filter by a calculated column/field. The calculated field returns yes/no and it displays YESes and NOs in the view on browser. But when filtered for Yes or ...
4
votes
2answers
7k views

How to add a custom filter for a chart?

I have a list which contains multiple columns. I have inserted the chart web part and it's showing the graph based on the column list. Now I want to add a custom drop down filter which contains column ...
4
votes
2answers
600 views

OR Condition in Query String SharePoint 2013

I use query string to filter SharePoint View =FilterField1TestField-FilterValue1TestValue-FilterField2AnotherTestField-FilterValue2AnotherTestValue. The above string performs AND operation between ...
4
votes
1answer
2k views

List Filter Webpart not loading default value from custom filter provider

I have a request from a client to filter the data in a list view webpart based off of some user controlled custom settings for our sharepoint applilcation. These user settings are stored in a ...
4
votes
1answer
1k views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external data source in a custom list. Today searching and filtering are not in place and actually exact matches are ...
4
votes
1answer
3k views

Dynamically setting Default Value in ParameterBinding through Javascript

To make a long story short (too late), we have a dropdownlist that is populated through a list of items. We want to use this dropdownlist to filter the list in a data view web part. This works ...