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

learn more… | top users | synonyms

0
votes
1answer
952 views

SP2010: Filter list in a WebPart by Contains not Equals (adding a wildcard)

This question isn't new here, but after reviewing existing posts I still need your advice. If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction ...
1
vote
0answers
12 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 ...
0
votes
0answers
10 views

using SpListFilterWebPart in sharepoint 2013

I want to use SpListFilterWebPart in allitems.aspx view in my share point 2013 and I do it with share point designer 2013 but I can't see SpListFilterWebPart in my page view Why it happened?
0
votes
1answer
31 views

Filter list based on dropdown selection - SP 2013

I would like to implement a list filter feature. I need to filter the list based on 3 drop down field values. The values of the drop down are populated from same list (that I want to filter). I am ...
2
votes
1answer
716 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 ...
1
vote
1answer
484 views

Display connection information within a ITransformableFilterValues web part

I created a filter web part by extending the ITransformableFilterValues interface, similar to this page: http://msdn.microsoft.com/en-us/library/ms499375(v=office.12).aspx. I want to mimic the ...
0
votes
0answers
24 views

How to get “SQL Server Analysis Services Filter” to work?

In an SharePoint 2013 BI Portal I am using two Report Services Report Web Parts with a common data source (.rsds file). Reports work fine and I want to filter the data of one report (or both reports ...
0
votes
0answers
29 views

Filtered Lookup Column from other Lookup Column

Why is this so difficult! SharePoint Online Office 365 List 1 : Group - Title, Desc List 2 : Category - Title, Group-Title(Lookup) List 3 : Document - Title, Category-Title(Lookup), ...
0
votes
1answer
326 views

Grabbing a filter value via CEWP code behind

I have employed a Query String Filter to parse a value and send it to a chart web part. now I would like to use this value in a CEWP to provide an explaination/clarification for the chart, but the ...
0
votes
0answers
21 views

View Month and Year of Group calendar

I have setup a group calendar using this article http://absolute-sharepoint.com/2014/06/create-color-coded-group-calendar-sharepoint-2013-step-step.html Now I see all the users in week view with all ...
0
votes
0answers
9 views

Is it possible to filter attachments field in InfoPath

When I copy "Click here to attach file" control in InfoPath and make multiple same attachemnts fields and then I upload files, those files apears in all fields. So is it possible to add a filter to ...
6
votes
4answers
6k 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 ...
1
vote
0answers
22 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 ...
0
votes
1answer
468 views

Unable to create valid SPDataSource Select Command

I am to use SharePoint Designer, no custom c# code. Currently using a SharePoint:SPDataSource on a DVWP to show a list. When the SelectCommand is blank it works fine but I will need to create dynamic ...
0
votes
1answer
47 views

Sharepoint filtered drop down list depending on group

I want to filter a drop down list within a list, depending on which group the user is bound to. Let's say that one group is called "green". The drop down list will originally have all different types ...
1
vote
1answer
24 views

Wiki search options

For example I have 2 wiki pages. First page includes such keywords as AD.180, AD.159, AD.200, second page includes keywords AD.300, AD.180, AD.159. If I search for AD.300 it displays me all pages ...
0
votes
0answers
17 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 ? ...
0
votes
1answer
1k 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 ...
1
vote
1answer
37 views

Hide forms in SharePoint list where checkbox = checked

Ok. So the problem I have is: I have a SharePoint online form library which shows a list of warranty claims, the warranty claim form has a "Claim completed:" checkbox - and what I want to happen is ...
0
votes
1answer
311 views

Filter Data View with SOAP Query as Source

I am creating a printable company directory. I have a SOAP Service query that pulls everyone's data from the search service. The query returns all the results I want. I have enabled the "Sort & ...
0
votes
2answers
36 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 ...
0
votes
1answer
24 views

Most Recent Documents / Items with Sort and Filter functionality

I want to have a Webpart that displays the Most Recent Documents for the entire site collection. Main concern with this webpart is that there is a requirement for Filter and Sort functionality for ...
0
votes
1answer
338 views

Items in folder not showing after filtering

following situation... The goal: i have a document library with different Project folders. Within these folders are various project files (exel - word - pdf etc.) that belong to that specific ...
0
votes
1answer
96 views

How can I build some search criteria with 9 fields

I am using SharePoint 2010. I have created a document library. In this document library I am using some custom contententtype with 9 fields. I would like to make some search page where it is possible ...
1
vote
0answers
19 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
1answer
801 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 ...
0
votes
1answer
330 views

Filter Parameter from Visual Web Part to XSLT or DataForm Web Part

I have a scenario where from Visual Web Part I need to send filter parameter to XSLTListView or DataForm Web Part on the same page! If I use Query String then I need to Response.Redirect and that will ...
1
vote
1answer
3k 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 ...
1
vote
0answers
27 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 ...
0
votes
0answers
4 views

Pull items from a column in order to populate filter options?

I have a column, participants, which is capable of including any one of 250,000 people. I expect the column to only be populated with 10-15 different names, but as people will join and leave the team, ...
0
votes
1answer
712 views

Default PPS Filter for PPS dashboard in SharePoint 2010 not showing

I have a PPS filter that I added to a PerformancePoint Dashboard. The default field for the filter was selected. When the dashboard is deployed through Dashboard Designer and viewed, the filter does ...
0
votes
0answers
8 views

<<UniqueName>>.Children in reversed order: PerformancePoint Dashboard

I am using PerformancePoint 2013. I have a filter with Calendar Year as its members. e.g. CY 2010. CY 2011 etc. I have a line chart which uses Calendar Month as a dimension in Bottom Axis, e.g. Jan ...
0
votes
0answers
19 views

SharePoint List Query Customisation

Is it possible to use SharePoint list query web part with parameters? So for example if I have a list which contains product codes, another column in the list will define whether each item is an ...
2
votes
1answer
1k 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 ...
0
votes
0answers
26 views

Does content query webpart connects to Text Filter

I dropped a Text Filter web part and CQWP on a page. Now I need to send the data from text filter to content query web part but there seems to be something missing. In the connection menu of Text ...
0
votes
2answers
46 views

Autopopulated list column with values from another column?

Please let me know if there is an easier way to do this.. I am attempting to perform an "OR" filter. I need to able to search a list by either the Title column or the Description column. I'm using ...
2
votes
1answer
19 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 ...
0
votes
0answers
35 views

SPGridView - when sorting AFTER filtering, column looses it's filtered state (filter not removable) How to solve this?

I've got a SPGridView in a webpart that has sorting, filtering, paging and grouping configured. Most of it works fine so far, but it seems like I can't get around this problem: If I filter the ...
0
votes
1answer
67 views

SharePoint 2013 Managed Metadata Filter and Sort Issue in List View

My managed metadata filter is working properly by itself. However, when combined with other fields, all of my data are gone. Here are the set of combinations where my data is gone. 1. a. Managed ...
0
votes
0answers
15 views

Mutiple Filters webpart

I need to create a webpart with the option to filter by two columns(i.e User and Team). So far I could create a webpart that implements ITransformableFilterValues however it only allows me to filter ...
0
votes
0answers
74 views

SharePoint 2013 - How to disable Filter and Sort item on view?

Is there any option to turn off or turn on "Filter" and "Sort" item on view of Share point 2013? I update Field properties: Filterable = false; Sortable = false It OK, but all Views of list is ...
1
vote
0answers
28 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
1answer
656 views

How can I Filter a Joined DVWP by [Current User] in Multi-User People/Groups field?

I have a joined DVWP. List A includes a "category" lookup field among other columns. List A includes the same "category" lookup field as well as a People/Groups field with multiple selections. I'd ...
0
votes
0answers
29 views

List Item Filtering for Adminsitrators

I have a list that I'm querying using RESTful uris like so: http://site/_api/lists/getByTitle('Links')/items Each item in the list has individual permissions applied to it (both users, and groups) ...
0
votes
0answers
62 views

Filtering list with HTML Web part using special characters displays back decoded symbol

I've set up a very simple HTML web part to filter results from a SharePoint list based on a particular column, and everything works great when I use the form to search for standard text like ...
0
votes
0answers
22 views

Total count of filtered list via webservices

In SharePoint 2013 I use a webservice to query a list: System.Xml.XmlNode node = myservice.GetListItems(listName, viewName, query, viewFields, rowLimit, queryOptions, null); I use CAML to apply ...
0
votes
2answers
36 views

How do I get a lookup column to filter in 2013?

I have data in page view that places the information for "project" in a lookup column. When I try to filter this column I get the error "this column cannot be filtered." How to I get this column to ...
0
votes
0answers
53 views

Query String (URL) Filter - show different SSRS reports for different parameter values

Is there a way that I can display different SSRS Report for different URL parameter? I have a URL parameter TestGroupID and I want the SSRS Report Viewer web part to show different report for ...
0
votes
0answers
21 views

Sharepoint 2013: can a page automatically filter content based on credentials?

Is there a way for Sharepoint 2013 to display only certain data on a page based on the credentials of the person logged in? To clarify: My project Director wants to visit a page and automatically ...
1
vote
2answers
361 views

Filtering List using CAML query and Binding it to dropdown in C#

I have the following code which retrieves all items from list "Employee Info" and bind it to Dropdown list EmployeeDD. if (!Page.IsPostBack) { DataSet ds = new ...