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

learn more… | top users | synonyms

11
votes
5answers
39k 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 ...
10
votes
5answers
10k 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 ...
9
votes
3answers
7k 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 ...
7
votes
1answer
3k 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 ...
6
votes
4answers
8k 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 ...
5
votes
2answers
3k 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, ...
5
votes
4answers
5k 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 ...
5
votes
1answer
631 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
1answer
901 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
5k 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
1answer
547 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 ...
5
votes
2answers
54 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 ...
4
votes
1answer
13k 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> ...
4
votes
2answers
3k views

Library view with subtree taxonomy filter

Let's say I have a following taxonomy tree: World |--Germany |    |-Frankfurt |    |-Berlin |--France      |-Paris ...
4
votes
2answers
4k 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 ...
4
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 ...
4
votes
2answers
5k 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 ...
4
votes
2answers
5k 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 ...
4
votes
2answers
4k 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 ...
4
votes
1answer
1k 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
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 ...
4
votes
2answers
1k views

How to limit a Data View Web Part to 1 Item Per (Most Recent)?

I have a DVWP that I need to set up a complex filter on. It WAS all set - grouped by category field, sorted by item title, then filtered on 2 other fields (year & quarter). Then I was given ...
4
votes
0answers
302 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 and ...
4
votes
1answer
709 views

Consumer+provider web part connections: output is asked before input

I created a simple web part that has both a consumer and a provider connection. The provided output depends on the consumed input (so this is a sort of pipeline approach). I managed to implement the ...
3
votes
1answer
9k views

Filtering a list with date ranges - xslt / advanced expressions on list filters possible?

I've got a Sharepoint 2010 list that I'd like to filter with date-ranges. I'm doing something like if END_DATE > [NOW - 1Week] and END_DATE < [NOW + 1Week] or PLAN_END > [NOW -1Week] and ...
3
votes
3answers
8k 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 ...
3
votes
2answers
3k 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 ...
3
votes
3answers
2k 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 ...
3
votes
3answers
3k 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 = ...
3
votes
1answer
88 views

Creating a view in SharePoint 2010

I have a ticketlist which has ticket_id for 2 different locations, tickd1,tickd2,tickd3,tickd4 for Dallas ticka1,ticka2,ticka3,ticka4 for Atlanta Now I am trying to create 2 views, one for ...
3
votes
1answer
456 views

Creating a custom Filter Webpart in SandBox? How-To?

Since a little while now I've been trying to create a custom filter webpart in Sandbox. So far, it seems that all the usual ways to create a custom filter webpart programatically ina farm solution are ...
3
votes
1answer
157 views

Filter Webpart to match any column

I have a list of products with hundreds of entries. Each product has contact details with it as well as company information etc. I would like to be able to run a search on this list and return ...
3
votes
1answer
3k 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 ...
3
votes
1answer
320 views

Is it possible to filter a BCS list using a site's name?

I'm running SharePoint Foundation and copying a site template per project. I would like to filter the BCS list in my template using the site name. Is there a possible method?
3
votes
0answers
145 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
3
votes
0answers
294 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
3
votes
0answers
361 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
3
votes
1answer
965 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 datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
2
votes
3answers
3k views

How to get value of List Filter web part in Javascript?

I use the SharePoint List Filter web part on a page to control several Data View Web Parts. How do I read the current value of the List Filter in Javascript?
2
votes
4answers
25k 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 ...
2
votes
3answers
2k views

Filter list view with url parameter. Strange behavior in Internet Explorer (SharePoint 2013)

I have a link opening the listview AllItems.aspx with specific filter parameter in the url which works fine. But if the user tries to change the filter of the prefiltered column, e.g. by selecting ...
2
votes
2answers
19k 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 ...
2
votes
3answers
437 views

How to filter a list by appended change date range of a specific column

What is the best solution to create a view having a filter on a column that has multiple change date? For example I want this to list items that have some modification on previous week
2
votes
3answers
416 views

Filter items with groups per user

I have a list of items where a field is a group of users. Is it possible to filter the list to that the person viewing the page will only see the items where he is a member of the users listed in the ...
2
votes
2answers
455 views

Creating a view filter

I have a litle issue to create a view. Let me summarize the case. There is a list with all the daily tasks, assigned to someone. I would like to create a view that shows one the assigned task to ...
2
votes
1answer
41 views

Filtering a grouped list via the URL - Rows excluded from the filter showing if group contains filtered rows

I am attempting to filter a list that is grouped by a field using parameters in the URL. My url is ?FilterName=Status&FilterMultiValue=Approved;Review As far as I know, this should return the ...
2
votes
1answer
2k views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
2
votes
1answer
228 views

“Save List as Template” losing Filter web parts but leaving false connections?

My InfoPath form web part remembers some false connections from the past, and cannot take any new connections after Save List as Template. What I did is this: Customize Form in browser (SP2013) ...
2
votes
1answer
175 views

[Today]-15 filter not working on external list

I have an external list which is getting data from SQL Server. The table structure is as follows: Name InsertDate Where InsertDate is the date when record was inserted. I am trying to show only ...
2
votes
3answers
5k views

Filter one list depending on selection in another list

let's say I have one list with my company's departments and one list with all employees. My list of employees has a lookup field to select the department. Now I want to have one page with a list of ...