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

learn more… | top users | synonyms

1
vote
1answer
2k 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 ...
0
votes
1answer
53 views
+50

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
17 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
3 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
678 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
7 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
15 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 ...
1
vote
1answer
521 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 ...
0
votes
0answers
18 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
34 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 ...
0
votes
1answer
876 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 ...
2
votes
1answer
16 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
15 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
45 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 ...
1
vote
1answer
478 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
1answer
27 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 ...
0
votes
0answers
12 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
1answer
313 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
20 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
18 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 ...
0
votes
1answer
304 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 & ...
1
vote
1answer
643 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
28 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
36 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
17 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
32 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
25 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
15 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 ...
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
2answers
258 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 ...
0
votes
1answer
28 views

How to filter web part content based on current wiki page taxonomy/category/keywords?

I have a series of simple wiki pages inside a Wiki Library (SharePoint 2010); As a test on a page, I have added a web part showing all wiki pages (w/ custom view), but I'd like to extend this web part ...
0
votes
0answers
33 views

Filtering Image Gallery with Javascript based on choice column

I used the article/script linked below to create a preview page of SharePoint 2010 picture library. http://weblogs.asp.net/bsimser/jquery-sharepoint-picture-libraries-and-automatic-thumbnails ...
0
votes
1answer
23 views

Filter lists based on user permissions

I am following this guide to help me solve my problem. However, it is causing issues when I try to save the edited code in SharePoint Designer. I would greatly appreciate If someone could help me ...
1
vote
4answers
83 views

How to filter calculated columns in the filtering menu

I would like to display my calculated columns fields in plain text in the filtering drop-down menu when I click on the column title. I don't know why SharePoint displays my calculated formula instead ...
0
votes
1answer
27 views

Use field in last item to filter the list view

I have a list which is updated about once a week with 50-100 new items through the use of Spreadsheet view and pasting from Excel. My problem is that I need to find what date when the list was last ...
0
votes
1answer
319 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
429 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 ...
1
vote
1answer
24 views

How do I change the web adress of a list?

I deleted a default list view and the web adress didn't change with that. So now it search for List/Old.View.aspx even though Old.View doesn't exist. This makes the site unavailable. How do I point ...
0
votes
1answer
30 views

How do I use the filter web part to sort out specific types of data from a list?

I am creating a landing page and was wondering how the filters works. Specifically, I want lists to be filtered depending on the user's permissions. So a user with contribute permissions for group A ...
1
vote
1answer
787 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 ...
1
vote
2answers
413 views

Sharepoint Foundation search filter? (Exclude all but SP wiki 'x')

I've looked (unsuccessfully) for what others have done on this topic. Within our Sharepoint Foundation site we have multiple wikis and we'd like to use the Search feature to search content from only ...
0
votes
1answer
323 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 ...
2
votes
2answers
738 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 ...
0
votes
1answer
29 views

Query String Filter Configure Connection not responding

So I have a Query String (URL) Filter, and a SSRS Report Viewer. I am trying to connect these two and a Configure Connection -- Webpage Dialog pops up and I can't do anything to my IE now. Normally ...
1
vote
2answers
673 views

XSLT filter for Yes/No Column/Field in SharePoint Custom List for SharePoint Designer DataView WebPart

I'm trying this with no luck: [@ActiveStatus='Yes'] also tried 1, '1', 'True' .. get no rows back.. If I remove the filter I get back all rows. full line in code view looks like this: ...
0
votes
1answer
80 views

How to render HTML/Plain Text to the filtering drop-down columns

I have a custom list, with some columns. In order to design my list with colors, I used calculated columns with a Content Editor Web Part which contains my script (JavaScript). I used this script : ...
0
votes
0answers
34 views

User Group Custom Filter

We all know how to get to "Site Permissions" and Add/Remove/Modify Users via "Site Actions" and we all know how to get to "People and Groups" via "Site Settings" Now, under "People and Groups" we ...
0
votes
0answers
20 views

Filter Current User - Me (hierarchy)

Is it possible to have a [ME] filter that allows anyone higher up in the user hierarchy to see items? For example I have the Team Leader who can visualize a list view in SharePoint, but I want that ...
1
vote
2answers
2k views

How to filter column in chart web part?

I have a list with 3 columns, Month, volvo, benz. I have created a chart which contains 2 series, volvo and benz. It shows 2 series based on month, for example for jan, it shows value volvo & benz ...