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

learn more… | top users | synonyms

9
votes
5answers
9k 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 ...
7
votes
5answers
28k 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 ...
7
votes
3answers
5k 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 ...
6
votes
4answers
7k 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
1answer
545 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
860 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
249 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 ...
4
votes
1answer
9k 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
2k 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
2k 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
909 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
4k 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
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
2k 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
1answer
632 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
8k 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
6k 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
929 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, ...
3
votes
2answers
93 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 ...
3
votes
1answer
85 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
430 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
125 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
2k 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
312 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
206 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 ...
3
votes
0answers
125 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
223 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
226 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
2answers
2k 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 ...
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
2answers
8k 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
412 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
1answer
22 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
2answers
2k 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 = ...
2
votes
1answer
164 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
138 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
1answer
969 views

How do I show a view of documents for the current user's department?

My first sharepoint task ever is to create a demo document management site, i need to define a way of departmentalising documents added to the store, then when a user logs in they only see documents ...
2
votes
2answers
449 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
2answers
526 views

How to filter a list on SharePoint

I am using SharePiont Server 2007 Enterprise with Windows Server 2008 Enterprise, and I am using publishing portal template. I am developing using VSTS 2008 + C# + .Net 3.5. I have defined a custom ...
2
votes
1answer
43 views

how to add a view filter to check if the login user is inside a group,same as for [Me]

I have added the following filter inside a view:- Which will filter if the “Assigned To” field equals the logn user. But now if the “assigned to” field contain a group which I belong to, then the ...
2
votes
1answer
677 views

Filtering datasheet view in Sharepoint 2010

I want to create a filter on Multiline Text Column inside a Datasheet View by means of out of the box features. Is it possible to provision such a feature so that when I click on the dropdown on such ...
2
votes
2answers
2k 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 ...
2
votes
2answers
235 views

Single Quote Issue While Filtering Records In SpGridview

In SpGridview single quote is breaking the filter expression as we are having filter format as "{1} like '{0}'",any idea how we can handle this situation.
2
votes
2answers
692 views

Disable filtering option on the list after the webpart page has loaded loaded completly

I am filtering a list by passing query string to a custom list http://TestSite/TestSubsite/Lists/TestList/allitems.aspx?FilterField1=FirstName &FilterValue1=Apelles This does the job of ...
2
votes
1answer
669 views

Pass list item metadata to filter for document library

looking for a way to filter a document library based on metadata from an item in a different library. For example I would have two web parts on a page , selecting on in item in library one would ...
2
votes
4answers
764 views

Web part filtering

For our web site we would like to be able to have a combo box which the end user selects a “Province/State” from the drop down menu. Depending on which “Province/State” he selects, some web parts will ...
2
votes
0answers
136 views

Filter.aspx and GetDistinctValues

We found an issue, that filters on columns are stop working. Error message is: Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the ...
2
votes
0answers
44 views

Meta data navigation filter on custom page?

I have a public facing website were i want our customers to be able to browse all our support documents using the Meta data navigation filter, but i dont want them to access the real document page. Is ...