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

learn more… | top users | synonyms

4
votes
0answers
285 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
143 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
292 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
336 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 ...
2
votes
0answers
61 views

How to create multiple operator options in one filter, and how to add “contain” filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no ...
2
votes
0answers
199 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
59 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 ...
2
votes
0answers
662 views

Modify XsltListViewWebPart XmlDefinition property not works as expected, filtering

I have got list with subfolders. I would like filter list items in current subfolder using additional caml query. I would like to add filtering functionality by modifing caml query. I try to update ...
2
votes
0answers
259 views

Filtering LookupMulti by FilterMultiValue SP2010

I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment FilterName=Tags&FilterMultiValue=Flower;Sword Three is nothing, apart correlation ID. I found in ...
2
votes
0answers
428 views

Custom filter provider web part and multiple values

I'm trying to build a custom filter provider that can detect the user language (the language selected in SharePoint by the user) and provide it as a filter. As a language can be represented in many ...
2
votes
0answers
237 views

DVWP ASP.NET Filter for all pages

I have created a drop down along with DVWP as described in http://social.technet.microsoft.com/Forums/en-US/sharepointcustomization/thread/949d4443-58a4-464b-9603-e4c280740650. However I see one ...
2
votes
0answers
1k views

SP2010: Strange Content Query Web Part Behavior - Inconsistent results between users

I'm experiencing some very strange behavior with a content query web part. The web part uses no customised XSL, and is a simple query of "All sites in this site collection, from a Document Library, ...
2
votes
0answers
729 views

Filtering a XsltListViewWebPart that has "Send Row of Data To“ connection doesn’t work?

Filtering of a XsltListViewWebPart is absolutely no problem when you change the webPart.XmlDefinition property like this: var xml = new XmlDocument(); ...
2
votes
0answers
260 views

Business Data Connector List Column not working BDC XML Definition

I have a BDC connected to a SQL Table with 2500 Rows. I'm able to add a Business Data List WP to a page and point it to the BDC source and it look fine except for limited number of Rows. However, if I ...
1
vote
0answers
40 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 ...
1
vote
0answers
43 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. ...
1
vote
0answers
47 views

View with `Current User Filter` doesn't work

I have a View of a List which uses the Office value of the UserProfile to filter the items, using a UserFilter Webpart and adding the Parameterbinding it works: <WebPartPages:XsltListViewWebPart ...
1
vote
0answers
14 views

Limit Dates available for selection and limit enteries displayed by those dates

I am creating a small timereporting list and would like to have the user select from a list of limited dates. The dates should be all the date for beginning of the week (i.e. 05/04/2015, 05/11/2015, ...
1
vote
0answers
49 views

Filter [Me] doesn't work correct

We have a task list with a filtered view for the users. The filter is "assigned to = [me]". Normally it works fine, but now there is one users who doesn't see all of his tasks. So i checked the ...
1
vote
0answers
136 views

Unable to filter Excel web access web part

I have an excel web app with a pivot table that's data comes from a powerpivot SQL data source. I am trying to filter this data via basic 'choice web part'. when applying the filter i get an error ...
1
vote
0answers
15 views

Linked webparts filter

I have a page with 2 linked webparts, actually 2 list views. (One view is simply sending a parameter to the other view). My problem is that when I use the list filter (by clicking on the view column) ...
1
vote
0answers
22 views

Recreating Extenal Item Picker for Internal Lists

SharePoint Online E3 License. SharePoint 2013 comes with a number of BCS Web Parts, one of which is a Filter WebPart. This can be connected to other BDC web parts on a page, or lists with an ...
1
vote
0answers
29 views

Select Default Filter in BDCM File

When working with Business Connectivity Services (BCS) and Business Data Connectivity Model (BDCM) files, does anyone know in the code where to set the "default" Filter and hide the option? Right ...
1
vote
0answers
62 views

Filtering list with managed metadata field dose not work in iFrame

I am working on a publishing site. As required, a view of pages library needs to be displayed on a page. The view contains a managed metadata field. If access the page directly, the view can be ...
1
vote
0answers
77 views

Odata Queries and Date Fields

I have a calculated field that contains the logic if(date) {Yes;} else {No;} This works fine for the column's calculation, but I either need to get the result of the calculated field or need to ...
1
vote
0answers
44 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
1
vote
0answers
140 views

When I click on the library setting “Metadata navigation settings” or “Per-location view settings ” got the error: Object reference not set to an

I am using sp2010. I have a document library with documents. I have 3 managed metadata columns in this library. When I go to the library settings and click on the option "Metadata navigation settings" ...
1
vote
0answers
56 views

Filtering list based on user preferences

On SharePoint I have 3 lists created. The 1st list contains 2 columns: user's unique ID and user's name. The 2nd list contains 2 columns: user's ID and a multiple choice of preferences of ...
1
vote
0answers
218 views

External List filtering using Web Part Connections (send filter value to)

I have an external list (WCF) and I would like to have another web part that searches 1 or more columns on the list (e.g. Product Title, and Product Status etc) I'm using SP2013, guess it would be ...
1
vote
0answers
159 views

Export filtered list to Excel in SharePoint 2013

I have a question about Excel export. I saw a bunch of negative answers on that, but not recent ones. In SharePoint 2013, is there still no out of the box solution to export a filtered list in Excel ? ...
1
vote
0answers
56 views

Sharepoint 2010 metadata filters- Driving from a link or script

The "old style" list filters in Sharepoint List views (e.g. when the user clicks on a column to filter or sort on column values) use an http GET, so the filter paramaters are transmitted in the page ...
1
vote
0answers
65 views

How to filter listview using webpart?

We have a list view webpart on a page. I want to create a textbox webpart and pass data into the list view webpart and filter it based on this data. Is there OOTB method? Or do I develop a VS ...
1
vote
0answers
146 views

Creating a survey with a question being lookup column with filtering

So I need to create a survey on a monthly basis with just one question. Possible answers should be the values from a lookup column, but limited only to those from the previous (calendar) month. Is ...
1
vote
0answers
415 views

SharePoint 2013 Online CQWP, using design manager can't filter on a managed metadata column

I reviewed a lot of articles and couldn't find anyone talking this issue. My issue is when I use Design manager to create a CQWP snippet, I always get error message when try to filter against a Page ...
1
vote
0answers
44 views

Documents inside a folder not showing when a filter is applied in query string?

I create a webpart to show the Document List on a certain page, and then I applied a filter on a column content to show only certain documents. But in that way the folder structure is lost and all ...
1
vote
0answers
146 views

Losing Filter When Paging Back From Second Page

I have a list view of a task list with filters creating subsets of tasks (Archived, Constructing, Defect, Stabilizing, etc.). The default view has a limit that will return 100 items at a time when ...
1
vote
0answers
322 views

Multiple filter value webpart connection problem

We currently try to connect a custom webpart with a list view webpart. The aim is to send multiple filter values to the list view. The problem we have is that the list view does only use the FIRST ...
1
vote
0answers
24 views

Create Connection beetween TextFilter and List

I have created a text filter webpart on my page and a list webpart app on the same page. If I edit the filter webpart it says that the filter is not connected and I should open the webpart editing ...
1
vote
0answers
76 views

Date range filter without SPD or Infopath

I am having a very difficult time trying to figure out how to create a page in SP2010 Enterprise that displays list items based on a user selected date range and status field is "approved" . ...
1
vote
0answers
155 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
1
vote
0answers
67 views

Send filter from Scorecard to Analytic Grid

The figure has an Analytic Grid at the bottom. It has a measure called [Application Count]. And it has a dimension named [Day Bucket]. At the top is scorecard. It has several calculated measures. ...
1
vote
0answers
300 views

SharePoint 2010 Data view web part filter values show all items when page loads

I prepared the data form web part with data source as SQL table on the page. On the same page, I created another list view webpart which contains items as parameters to filter SQL data through ...
1
vote
0answers
188 views

People column cannot be filtered by empty value

I have a list in which there is a people column. I used to be able to filter the list by empty values in the column, but that has abruptly stopped working. That is, normally, I should be able to ...
1
vote
0answers
894 views

PerformancePoint Filters do not work (Sharepoint List as data source)

Tabular data source filter problem in PerformancePoint Dashboard Designer Dear all, Your suggestion on the following problem resolution will be highly appreciated. SharePoint 2013, Analysis ...
1
vote
0answers
49 views

How I create a View for more lists?

It is my first question and I a noob in Sharepoint but I get a task to set a view for a list. I explain the idea. Our company has a teamsite where we can see who have task and who do this task. Now ...
1
vote
0answers
166 views

Filter a connected list- How to show all by default?

I have two lists embedded as individual webparts on my SP2010 page. The two lists are connected so that the first list can act as a filter for the second one- there is a column which is common between ...
1
vote
0answers
75 views

Filtering Multi-Selection Lists

I am having trouble filtering a multi-selection list, and I think the problem is with the reference to the current item. I need a way to reference the item that the filter is being checked against ...
1
vote
0answers
118 views

InfoPath current() Function in Multi-Lists

When you call current() from a multi-selection list, where does it resolve to? I ask because I need to use it in a complicated filter to control what values are present in the list. Has anyone used ...
1
vote
0answers
100 views

Customize Filters in Document Library

We got several document libraries which has a column type. This like all other columns can be filtered by values that is inserted on the document library. In Type, we got file types like doc, docx, ...
1
vote
0answers
214 views

Sharepoint Webservice not filtering Data

Working Version Issue: I am querying SharePoint using SP CAML Query Helper. Using SPCQH I am able to retrieve one order. The query works. Once I add the query to my Biztalk solution the query below ...