Tagged Questions

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
712 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
331 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
29 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
178 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
543 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
227 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
435 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
326 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
244 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
2k 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
3k 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
647 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? ...
4
votes
1answer
9k 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
164 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
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
983 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
666 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
839 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
269 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
719 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
155 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
776 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
424 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
591 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
2answers
663 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
943 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
702 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
612 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
224 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
85 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
723 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
1k 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
8k 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
515 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
1k 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
680 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(); ...