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

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 ...
0
votes
1answer
82 views

COMException due to WebPart Connection while trying to Filter provider list web part

In SharePoint 2010 I see the following symptoms: We have three lists, looking up to one another in a chain. Sample: Vendors [30] as root; Projects [100], Looking up to Vendor; Deliverables ...
1
vote
1answer
461 views

How to filter a sharepoint list

I have a custom list called expenses. The list has fields such as user,date,amount etc. I want the user to be able to filter this list by amount e.g. add a dropdown above the list with a search ...
0
votes
2answers
936 views

How to add programmatically Sharepoint List Filter Wep Part?

I try to add Sharepoint List Filter Web Part to page. I'm not sure if it is Microsoft.SharePoint.Portal.WebControls.SpListFilterWebPart. How to add it to the page and configure? Update ...
1
vote
1answer
221 views

SP 2010 REST $filter column

I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
1
vote
2answers
212 views

Can i filter folders to show on different views

How can i make it so that certain folders appear on different views? ex: View 1 (Folder A, Document A1, Document A2, Document A3) View 2 (Folder B, Document B1, Document B2, Document B3) View 3 ...
0
votes
2answers
307 views

Capture filter value, within xslt, passed in from connected web part

Is it possible to get hold of the value of a filter being passed in by a connected web part? For example, if a sharepoint list filter is sending a filter value of "1" to webpart A (a dataview ...
0
votes
1answer
49 views

Send dvt_curselkey values between 2 pages

I have list (Plans of subdivisions) which I filter by several parameters (Division, year, quartal). I do this through multiple dvwp connections. So there is a parameter dvt.curselkey for each dvwp, ...
4
votes
2answers
3k 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 ...
1
vote
0answers
301 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 ...
1
vote
3answers
355 views

How to filter a list by appended change date range of a specific column

What is the best solution to create a view having a filter on a column that has multiple change date? For example I want this to list items that have some modification on previous week
0
votes
1answer
53 views

Is there a workaround to managed property?

Basically I am working on a sharepoint site, but the company I am working for have not given me central admin access. We have created a custom search and need to filter some list searches by columns. ...
1
vote
2answers
860 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 ...
0
votes
2answers
2k views

Add Listview of parent site list

i want to add a page where users can view and edit a list, problem is the list is not in the site but rather in its parent site. I also want to be able to filter the list so they can only see a items ...
1
vote
2answers
334 views

Filter Library with parameter

I am an intern at a company, so I am not completely sure about the structure of the servers etc. However, I have a library that I want to filter by the department that the currently logged on user is ...
1
vote
2answers
1k views

Sharepoint 2010: List view to always show last friday's data

I've been working on this issue forever now...Here's what I'm trying to do. I have a custom list where people add some info. I crated 2 views to view items added today and yesterday. Now I'm trying to ...
0
votes
1answer
154 views

Is it possible to use an IF expression to filter column choices depending on previous column?

I am creating a site for training documents. I have 2 fields, topic and category. Is it possible to filter the options within category depending on which option the user selects in the topic column ...
0
votes
3answers
3k 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 ...
0
votes
1answer
98 views

Filter webpart sharepoint 2007

Hi I need to add filters on search results page in sharepoint 2007, Please guide how to do that. My requirement is quite similar to Filter webpart on the Search Page Thanks in advance
0
votes
2answers
661 views

Send Paramets from HTML form to DVWP via javascript

Good day! I have a DVWP. DVWP has parameters as query string "StartDate" and "DateEnd" and filters on datefield "Date" by parameters "StartDate" and "EndDate". Also I have form on the page with ...
0
votes
1answer
307 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
1answer
2k views

Query String, Can I show single item from a list using a query string?

Used this to pass a value to a form, but can I use a query string for a single list item ID, provide to users and have that filter a list for me? Or do I need some CQWP that takes a parameter from a ...
1
vote
0answers
25 views

Is that possible to filter and display the lookup values? [duplicate]

Possible Duplicate: How to make a filtered lookup field I am using project list lookup field in task list, so my project have # of items, but i need to restrict some of the project like if ...
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 ...
2
votes
1answer
172 views

Filter current user by two values

Is there any way to set the filter for a web part to be seen by two people? for example, in my infopath form, i have a traveler from the active directory, and the creator of the form, who are not ...
0
votes
2answers
473 views

multi filter with URL values

I know that I can filter a single field with a single value using parameter passing to a view or a page. Something like: URL?FilterField1=ColumnName&FilterValue1=ValueToFilterOn My ...
2
votes
2answers
210 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.
0
votes
1answer
2k views

User Profile Synchronization - Filter by AD OU or DN attributes

I am attempting to filter out a subset of users in Active Directory from being pulled into the User Profile Service. The users need to be filtered by the Organizational Unit property (ou), which is ...
0
votes
2answers
2k views

Filter list by multiple possible values

I want to filter list by multiple possible values of one specified field, how can i do this in code? I have following lists: Initiatives, Classes of Initiatives and Departments. I need to retrieve ...
1
vote
2answers
415 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 ...
1
vote
3answers
3k views

Page a list via A-Z

So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it. So I was thinking use ...
1
vote
1answer
281 views

Turn filter on by default on a sharepoint view

I would like to filter a column defaultly on my SharePoint view, is it possible to do so ?
0
votes
1answer
227 views

SPGridview Filters date formatting issue

I have an issue with spgridview filters, in my grid view i have column that contains start date and i have to display date in "yyyy-MMM-dd" format, i am able to do this with the custom itemtemplate ...
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 ...
1
vote
1answer
1k 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 == ...
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
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
3answers
597 views

Is that possible to use != in query string?

I am filtering sharepoint list using query string for some reson i need to check condition like FieldValue!=Red is that possible to achive? Or still its limitation? ...
3
votes
1answer
7k 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> ...
0
votes
1answer
161 views

Multiple identical values in dropdown list control

I am making a page which has a web part view and dropdown and search filters. I have added datasource controls, parameters and connected these to the relevant drop down. added appenddata bound ...
0
votes
2answers
4k 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 : ...
0
votes
1answer
957 views

Using a list view to filter another list view

I have two lists; List A and List B. List B has a lookup column to List A. I want to filter List B based on the value in the field that looks up A. This can of course be done using the default OOTB ...
1
vote
1answer
638 views

Need Filter to calendar list i.e for calendar.aspx page

For Calendar List - web part connections doesn't work and query string doesn't work. So I am out of options here. Can any one guide me to how to filter the calendar list data in calendar.aspx. I am ...
1
vote
1answer
764 views

Calendar DVWP to show only today with recurring and all day events

I got a interesting problem here. I developed a dashboard for one of our departments, they wanted a widget that shows only today's events. I have the DVWP in place, and filtering by a calculated ...
0
votes
1answer
2k views

Filtering sharepoint external list (BCS) from infopath

My requirement is to pull external data to InfoPath form based on a filter (e.g. Name filter) to Acheive this I did below things (I am working on InfoPath 2010, SP 2010) I have created a BCS to pull ...
0
votes
2answers
256 views

increase List threshold or Custom Filter?

I have a list over 200,000 items in it. It's on normal threshold (2,000 items per view). Users want large threshold but there is price for that. SQL traveling/transaction, server overhead and the ...
1
vote
1answer
38 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
669 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
0answers
153 views

Column filter values

When you view a list/library in SharePoint you have the ability to filter on a selected column. For instance, you have a column called "Food" and you may want to filter the results based on a value ...
0
votes
1answer
722 views

On a SharePoint list view with filtering, I want to apply jQuery to the filter list, which isn't built until the user clicks the menu

This project is in MOSS, using jQuery 1.6.1. The basics of what I need: When the user filters on a date field, the value of the filter option needs to be "yyyy-M-d" while the text is "M/d/yyyy." ...