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
354 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
3answers
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
693 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
11k 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
665 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 ...
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
980 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
722 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
414 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
5k 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
527 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
77 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
2answers
813 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
2answers
776 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 ...
3
votes
1answer
275 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
53 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
361 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
678 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
451 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
320 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
393 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
472 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
394 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
733 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
1answer
122 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
147 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
181 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
688 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
497 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
187 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
36 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
2answers
633 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
901 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
9k 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
86 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
777 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
174 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
382 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
196 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
4k 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
427 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
380 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
123 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 ...
