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
2answers
5k 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
966 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
645 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
789 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
260 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
698 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
734 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." ...
0
votes
2answers
1k views

How can I filter a list based on the day of the week?

We have a Sharepoint list which contains a user's name, various areas of duty, and the weekday name for that roster. For example: Name Recess Lunch Day Joe Area 1 Area 3 Monday Fred Area 4 Area 2 ...
3
votes
1answer
416 views

Creating a custom Filter Webpart in SandBox? How-To?

Since a little while now I've been trying to create a custom filter webpart in Sandbox. So far, it seems that all the usual ways to create a custom filter webpart programatically ina farm solution are ...
1
vote
1answer
5k 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 ...
1
vote
1answer
570 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 ...
0
votes
1answer
1k views

SharePoint 2010 List items - visual filtering based on timeline and other attributes? [closed]

I am trying to design a visual filter & View for a standard Sharepoint List. Something similar to this one: http://www.aoglobalview.com/#/regulation-timeline/Clearing/global Each List Item has 4 ...
2
votes
1answer
614 views

Disable filtering option on the list after the webpart page has loaded loaded completly

I am filtering a list by passing query string to a custom list http://TestSite/TestSubsite/Lists/TestList/allitems.aspx?FilterField1=FirstName &FilterValue1=Apelles This does the job of ...
1
vote
2answers
898 views

spgridview clear filter programmatically

I have a textbox a button and a spgridview. When the button is clicked I will search SharePoint with the value in the textbox and bind it to the spgridview. (I'm using LingDataSource). After I filter ...
1
vote
1answer
661 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 ...
4
votes
1answer
1k views

List Filter Webpart not loading default value from custom filter provider

I have a request from a client to filter the data in a list view webpart based off of some user controlled custom settings for our sharepoint applilcation. These user settings are stored in a ...
4
votes
1answer
587 views

Consumer+provider web part connections: output is asked before input

I created a simple web part that has both a consumer and a provider connection. The provided output depends on the consumed input (so this is a sort of pipeline approach). I managed to implement the ...
2
votes
0answers
214 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 ...
3
votes
1answer
84 views

Creating a view in SharePoint 2010

I have a ticketlist which has ticket_id for 2 different locations, tickd1,tickd2,tickd3,tickd4 for Dallas ticka1,ticka2,ticka3,ticka4 for Atlanta Now I am trying to create 2 views, one for ...
0
votes
2answers
707 views

FullTextSearch: SPSiteDataQuery on each request vs. caching data and filter in code

I'm implementing a full text search on list contents. Is it more efficient to fire a SPSiteDataQuery on every request with a dynamically built CAML-Query, to filter the items? Or is it better to ...
2
votes
0answers
978 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, ...
3
votes
1answer
7k views

Filtering a list with date ranges - xslt / advanced expressions on list filters possible?

I've got a Sharepoint 2010 list that I'd like to filter with date-ranges. I'm doing something like if END_DATE > [NOW - 1Week] and END_DATE < [NOW + 1Week] or PLAN_END > [NOW -1Week] and ...
0
votes
1answer
1k views

Filter form for a list

I have a Sharepoint 2007 site and want to create a list that users can filter dynamically using a form or something similar. The use case is as follows: A user is shown a list with any number of ...
1
vote
0answers
497 views

PageNumber-Fillter for Finder in .Net Assembly Connector

I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following. <Method ...
2
votes
2answers
951 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
664 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(); ...
1
vote
2answers
2k views

How can create a view to filter the a list based on the current login user

How to create a view based on the current user is in a Person or Group field , this Person or Group field can contain multiple user but not SharePoint Group ,I try to use the contains to filter the ...
1
vote
1answer
804 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 ...
5
votes
1answer
5k views

Can I Filter a List/Data View using Contains instead of equals in SP2010?

I have a page where I am using a Text Filter to filter a long (15K) list of clients in a Business Data List web part. The filter works fine for All and for an entered name, so long as the full name is ...
1
vote
0answers
237 views

Filtering one List Part, by another Web Part, where the Second web part has a filtered View

I have one list, called "Company Reports" and another list "Companies" The Companies list has a field called Include(yes/no), and I have created a View which filters it to only show active companies. ...
1
vote
1answer
488 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 ...
1
vote
0answers
141 views

BDC Lightning tool on MOSS 2007. Using BDC in Picker and filtering

I've got a BDC I generated with BDC Lighning BDC Man. I added a BDC column to a list and when I open the address book picker I get the first 200 entries but search/filter does not work. Anybody know ...
1
vote
2answers
918 views

SharePoint Designer: CurrentDate CAMLVariable is incorrect to compare to date column

I am creating a simple form by "Insert Data View" web part and filtering on the data source by date. Something like: Displays all the announcement items that have: "Expires" Greater Than Or Equal ...
1
vote
1answer
118 views

Filtering List for “created by” of currently displayed user

Hey i'm trying to filter a list for the currently displayed user in the mysites. There is a list "projects" with all projects in it. If i navigate to some co-workers profile in the mysites he has a ...
2
votes
0answers
243 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 ...
4
votes
1answer
2k views

Dynamically setting Default Value in ParameterBinding through Javascript

To make a long story short (too late), we have a dropdownlist that is populated through a list of items. We want to use this dropdownlist to filter the list in a data view web part. This works ...
0
votes
1answer
134 views

Link with QueryString

I have a webpart page with a Query String Filter. That works fine, but I also need some links on the web part page that uses the querystring. Any ideas? Update: Sorry for bad explanation. On the web ...
1
vote
2answers
120 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 ...
7
votes
5answers
24k views

How to make a filtered lookup field

I have a list of departments. This list will change over time adding new departments and "deactivating" others (because of structural changes). I would like to use this list as a look-up for other ...
0
votes
1answer
700 views

Webpart to show documents, it's folders and underlying files

I have few document libraries with lot of folders and files in it. The Out of box webpart shows in sequential way and every click does a page refresh (sometimes users get lost of focus when it ...
1
vote
1answer
1k 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
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:", ...
2
votes
1answer
622 views

Pass list item metadata to filter for document library

looking for a way to filter a document library based on metadata from an item in a different library. For example I would have two web parts on a page , selecting on in item in library one would ...
1
vote
2answers
788 views

MOSS 2007 - Filter calendar to display currently running event

I want to create a view for a calendar. The view must display only currently running events. Right now, I can create a view that filter on for daily event : I currently filter events with Start Date ...
0
votes
2answers
169 views

custom functionality on page

I'd like some advice on how to create the following: My customer has a SharePoint site with an order list on it (just a regular sharepoint list). The orders can have an attachment. On the main ...
7
votes
3answers
5k views

Show folders in document library that have a filter view

I am using SharePoint 2010 I have a document library with a view that Filter items only when a particular Column is true. The problem now is that when I have a filter in my view the folders in my ...
1
vote
1answer
130 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 ...