A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.
6
votes
3answers
2k 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 ...
6
votes
4answers
6k views
Paging and sorting with BCS
I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
5
votes
1answer
338 views
Only show Sorting option not filtering opetion in contex menu of header in ListViewByQuery
I have creatd ListViewByQuery control through coding and added the control through RencerControl Event.
I am filtering the list in code. so filtered result is shown. I want to hide filter context ...
5
votes
2answers
4k 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 ...
5
votes
1answer
3k 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 ...
5
votes
1answer
665 views
Sharepoint 2010, Document Library, Key Filter - “Modified” field filtering is out by one day
We have a Sharepoint 2010 farm across 4 servers and added "modfied" as a Key Filter for metadata navigation. When I select to filter on a specific day I enter a date the filtered results are out by ...
4
votes
5answers
10k 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 ...
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 ...
4
votes
2answers
950 views
How to limit a Data View Web Part to 1 Item Per (Most Recent)?
I have a DVWP that I need to set up a complex filter on.
It WAS all set - grouped by category field, sorted by item title, then filtered on 2 other fields (year & quarter). Then I was given ...
4
votes
1answer
709 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
399 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 ...
3
votes
1answer
4k 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 ...
3
votes
3answers
3k views
Why are documents inside a folder not showing when a filter is applied?
I added a custom column called Project (string) to a Document List.
I then set different views in different pages to filter on that column.
The problem is that, when applying the filter, documents ...
3
votes
2answers
438 views
Library view with subtree taxonomy filter
Let's say I have a following taxonomy tree:
World
|--Germany
| |-Frankfurt
| |-Berlin
|--France
|-Paris
...
3
votes
1answer
75 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 ...
3
votes
1answer
641 views
Use Term Store as a Filter Webpart
I have a couple of libraries that share a term store field for Clients. I put two list views on a page and planned on using the term store navigator to filter the lists, but couldn't find it in the ...
3
votes
2answers
669 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 ...
3
votes
1answer
271 views
Is it possible to filter a BCS list using a site's name?
I'm running SharePoint Foundation and copying a site template per project. I would like to filter the BCS list in my template using the site name.
Is there a possible method?
3
votes
1answer
45 views
Filter Webpart to match any column
I have a list of products with hundreds of entries. Each product has contact details with it as well as company information etc.
I would like to be able to run a search on this list and return ...
2
votes
3answers
357 views
Filter items with groups per user
I have a list of items where a field is a group of users.
Is it possible to filter the list to that the person viewing the page will only see the items where he is a member of the users listed in the ...
2
votes
1answer
648 views
How do I show a view of documents for the current user's department?
My first sharepoint task ever is to create a demo document management site, i need to define a way of departmentalising documents added to the store, then when a user logs in they only see documents ...
2
votes
2answers
444 views
How to filter a list on SharePoint
I am using SharePiont Server 2007 Enterprise with Windows Server 2008 Enterprise, and I am using publishing portal template. I am developing using VSTS 2008 + C# + .Net 3.5. I have defined a custom ...
2
votes
1answer
318 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 ...
2
votes
1answer
376 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 ...
2
votes
1answer
466 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 ...
2
votes
2answers
391 views
Creating a view filter
I have a litle issue to create a view. Let me summarize the case.
There is a list with all the daily tasks, assigned to someone.
I would like to create a view that shows one the assigned task to ...
2
votes
4answers
732 views
Web part filtering
For our web site we would like to be able to have a combo box which the end user selects a “Province/State” from the drop down menu. Depending on which “Province/State” he selects, some web parts will ...
2
votes
2answers
739 views
List View Filtering on Managed Metadata Fields issue
I’ve got some issue where I think I need your help
Our client asked for change in list view filtering to not show all terms from taxonomy in managed metadata, but only these from documents in ...
2
votes
1answer
120 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 ...
2
votes
2answers
140 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.
2
votes
0answers
177 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
1answer
664 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
0answers
478 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();
...
2
votes
0answers
180 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 ...
1
vote
3answers
2k 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
2answers
477 views
How to get value of List Filter web part in Javascript?
I use the SharePoint List Filter web part on a page to control several Data View Web Parts.
How do I read the current value of the List Filter in Javascript?
1
vote
2answers
846 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
4answers
8k views
Filter a list view using URL parameters
I would like to dynamically construct a couple of URLs for our SharePoint users to filter down a rather large list view we have. Rather than create a bunch of different custom views, I was wondering ...
1
vote
1answer
3k 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
2answers
84 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
747 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
1answer
147 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
308 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
3answers
183 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
1
vote
1answer
3k 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>
...
1
vote
1answer
34 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
417 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
122 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
304 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
863 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 ...
