A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.
0
votes
0answers
237 views
Connect Date Filter Web Part to a List
I am currently trying to connect a Date Filter Web Part to a list, where the date filter will be filtering based on the list items Created feild. It connectes but the disconnects.
Below are the steps ...
0
votes
3answers
421 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?
...
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>
...
0
votes
1answer
151 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
2k 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
771 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
417 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 ...
0
votes
1answer
554 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
1k 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
204 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
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
0answers
139 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
513 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
697 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 ...
2
votes
1answer
319 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
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 ...
0
votes
1answer
374 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
680 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
380 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
526 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
510 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
713 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
402 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
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 ...
3
votes
1answer
76 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
541 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
1answer
666 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
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 ...
0
votes
1answer
720 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
353 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 ...
1
vote
2answers
703 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
483 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
855 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
562 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
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 ...
1
vote
0answers
191 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
304 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
116 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
613 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
96 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
183 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
121 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
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 ...
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 ...
0
votes
1answer
462 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
750 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
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:", ...
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 ...
