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

learn more… | top users | synonyms (1)

2
votes
0answers
244 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
2answers
1k views

Filter an External List on a datetime Field

So I have an external list in SharePoint 2010 that connects to a SQL database and pulls the data successfully. I also have 2 filters defined along with a limiting (TOP) filter. The first filter is ...
2
votes
0answers
774 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(); xml.LoadXml(...
2
votes
1answer
1k 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
0answers
263 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 ...
2
votes
2answers
1k views

Seemingly random (non-alphabetical) ordering showing up in List column filter options?

I am using SharePoint 2007 (MOSS) and I have stumbled across a rather odd issue. I have a list that has a Lookup column to another list, which works fine. However, when viewing the list and trying to ...
1
vote
4answers
8k views

REST service $filter Date column

Using the REST services, I'm trying to filter by the Created column, which is a Date data type. When trying to $filter on that column, I passed in the same date format that comes back in the JSON ...
1
vote
3answers
3k views

Create a web part to display filtered list item

I've got a Contact list with info about departments in our organization. The list is at the department level, not person level. It has the following columns: Department Title ["Contact Helpdesk:", "...
1
vote
3answers
33 views

Filter view by current year

I have a Year column and I already know that it's not possible to filter a view using Year equals =YEAR([TODAY]) and use [TODAY] in calculated columns does not work as expected. Does there exist a ...
1
vote
1answer
3k views

Getting document name using REST (not title) while filtering document library

I am trying to filter through a list and return metadata of the documents in that filter. How do I return the name of a document from a document library using REST while being able to filter the ...
1
vote
2answers
2k 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 DataSet();...
1
vote
2answers
2k views

Workflow Task List - View Filtered By Assigned To = [Me] not working for SPGroups

I want to filter my Workflow 2013 Tasks list only to display the tasks assigned to the current user. Hence I went ahead and set a filter 'Assigned To' is equal to [Me] in the view. However, I am not ...
1
vote
2answers
362 views

How to write a caml query that filters by .pdf or folders?

How can I write a CAML query (for javascript ecma) that filters by only pdf documents or folders in sharepoint 2010? (this is for document libraries) Thanks.
1
vote
1answer
38 views

View List with 2 filtering

I want to add 2 filtering a list. List item not to be shown after the Closing date List item not be shown till the Publish date reaches. I've added a Closing and Publish Date on my list. But not ...
1
vote
4answers
2k views

Filtering REST call with lookup field

We have a column defined on a custom list that allows for multiple select of values from another custom list. The column on the list is call Panels. When I do a REST call against this list, I can ...
1
vote
4answers
257 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 ...
1
vote
1answer
1k views

Multiple filters on view not working

I have a list on which I am applying the following filter (on a view) but it is not working. if((workflow == 16 && status == published) || (workflow == 2 && status == expired)) ...
1
vote
1answer
43 views

Can I enter a value string as one condition of a view's filter?

For example, could I, in one rule, filter a view based on "Show the items when column x contains a, b, or c?
1
vote
1answer
7k views

Filtering data programmatically on SPView

I would like to know how can I filter information in SharePoint list (Library of documents) programmatically. I have tried 2 ways but they don't solve my problem: Using the string lsWebPart....
1
vote
2answers
155 views

Filtering Lists with A and ( B or C)

Filter = A and ( B or C ) For a sharepoint list, how does one get the above behavior? For example, the default behavior would be Filter = A and B or C Specifically, the desiresed filter is ...
1
vote
1answer
2k views

SharePoint 2010 - Add filter to a list with PowerShell

How it is possible to add a filter to a list with PowerShell? (I want to add a filter to multiple lists) Is there any tutorial, articel or example?
1
vote
2answers
30 views

Can you set a text filter value in a hyperlink?

I have been trying to find information on how to do this. I have a web part page that has 3 lists, and those 3 lists are are all connected via a text filter. The goal is, to create a link in a ...
1
vote
1answer
27 views

SharePoint view issues

I'm having some issues on a SharePoint list view. I have a people picker column "Work Allocated" and have enabled the Folders in the list view. I'm creating folders for each month and I would want the ...
1
vote
2answers
50 views

How to filter webpart for multiple values

I've added a list webpart (using UI) to a webpage and also added a Choice Filter Webpart. It appears I can only filter the list using a single value, i.e. multi-values are not supported. Is there any ...
1
vote
2answers
52 views

What is the French equivalent of [Today]?

I'm creating a view in French where it filters on items greater than today's date. Unfortunately, I cannot find the French equivalent for [Today]. Anyone know? Thanks.
1
vote
3answers
1k views

Retrieving files from a document library using REST with a filter on a field

I have a standard document library with one added field StudyId (string). I can't figure out how to retrieve files using a filter on that field. I retrieve files as following: http://test-site/_api/...
1
vote
3answers
657 views

Sharepoint 2013 CQWP - Filter by Approval Status

I'm kind of stuck in a Content by Query Webpart. (Yes, i'm aware i'm on 2013, and yes, i could use Content by Search WebPart, but this is a standard edition, so no, finally i can't use CSWP) I would ...
1
vote
2answers
2k views

Filter lookup column based on another field value

Scenario: I have Tasks list with a (lookup) column Project. I have also a multivalue lookup column Predecessors pointing to the Tasks list itself. Question: Is it possible to filter available Tasks ...
1
vote
1answer
46 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 ...
1
vote
1answer
378 views

Multiple filters with query string

Imagine this situation: a SharePoint 2010 teamsite 2 lists 1 query string filter webpart to connected to the first list the 1st list is connected to the 2nd to filter the 2nd When I click an item ...
1
vote
1answer
361 views

How do I set FilterOperator1 in the URL?

I know I can filter a SharePoint list by adding ?FilterField1=fieldname&FilterValue1=value to the URL. Microsoft's documentation also lists a property FilterOperator1 that you can use if you want ...
1
vote
2answers
2k 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: <xsl:...
1
vote
1answer
555 views

Autocomplete filter using Sharepoint PerformancePoint Dashboard Designer

I am using Sharepoint 2010 with PerformancePoint Dashboard Designer. I am creating a dashboard that has a filter at the top of the page. The filter contains a very long list of items and I was wonder ...
1
vote
1answer
5k views

What is correct syntax for filtering a list on field values?

Salvete! I want to filter a list like this. Now, [othercolumn] is supposed to be the value of the field in the X-Field column. I want to see if the X-field column contains the text given in the ...
1
vote
2answers
1k views

Custom Search Page Filter Results

I have created a custom search page with a core search web part. It builds a query string in URL to populate the search results. k=[keyword] is the first, then to narrow the search to specific ...
1
vote
2answers
3k 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 ...
1
vote
1answer
2k views

SharePoint - Showing folders in a filtered view

I have a library with a few folders in it, and the files in the folder have a "Status" property and an "Assigned To" field. I want to make a view with the following logic: If (Content Type == Folder)...
1
vote
1answer
2k views

Filter Multiple connections List (no-code solution)

I have a mission to create a filter for any field of my list, there are many. The connection is just made in the first filter, I cannot connect more than once... I've searched for code which would ...
1
vote
3answers
14k views

How to apply 2 different conditions in the filter of list?

I have two different conditions based on which I need to apply filter on the list data. The conditions are based on the user role and status column. I have applied the filter condition as : ...
1
vote
1answer
934 views

How to format the spgridview filter data?

I have a SPGridView where I am binding a calculation field. I am dynamically binding data to sp grid view in a web part. The filter value is displaying like String;#filterexp1, String;#filterexp3, ...
1
vote
1answer
857 views

Filter by metadata through connection to another item

I was wondering if it is possible to filter a list item based on metadata values from another list item. I tested it locally but it didn't seem to work althougth another post here said it should work ...
1
vote
1answer
136 views

Best approach to implementing a forced filter on a site?

I'm relatively new to SharePoint development so please excuse the question if it is an obvious one. Environment I have a site hierarchy that looks like this Client Dashboard Client sites (one or ...
1
vote
1answer
439 views

Filtering for recurring events happening [Today]

Is this possible? Ryan Wheeler says its not here. Tim says it is if your view is of type "Standard View, with expanded recurring events" here. I haven't been able to get Tim's suggestion to work. (...
1
vote
2answers
2k views

Sharepoint View Filter (how to check for nulls in Scheduling Start/End Date)

I am trying to use the built in sharepoint U.I to setup a filter for Scheduling Start Date & Scheduling End Date. However I noticed that if you setup something with a "Scheduling Start Date" as "...
1
vote
1answer
2k views

Multiple filters in ECT External Item Picker in SharePoint 2010 BCS?

I am using SharePoint 2010 BCS to connect to a SQL Server database table and created an External Content Type (ECT). In this ECT you can specify a filter and I have done that, and I mapped the ECT to ...
1
vote
1answer
694 views

How do I use a javascript variable in the Filter Criteria for a DVWP?

I am converting some numbers using Javascript and need to filter a list using these conversions. I cannot do the conversions within SharePoint itself, so I had to use Designer and some Javascript. I ...
1
vote
1answer
26 views

Multiple filters in a list

I am using SharePoint online and want to add multiple filters on the list without coding. To enable the user to use different filters on the list. For example choosing created between two dates and/or ...
1
vote
3answers
54 views

Need to filter a list with 10+ criteria

Need to create a list filter with over 10 criteria. Research tells me that it can be done with a Data View web part but I have not found any instructions on how this is done.
1
vote
1answer
55 views

Multiple columns $filter in SP designer 2013 http web service call

How can I filter on multiple columns when making a web service call in a SP 2013 designer workflow? For example if this is the url for the service call then how is the $filter part different from what ...