.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to filter a List View by multiple values for one filter field?

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
Hi, I need to create a dynamically created link to a List View with a filter on one field, but with multiple values. Example: http://<server>/Lists/<list>/Allitems.aspx?FilterField1=Name&FilterValue1=John/Jack/Jonas which should give me all items where Name equals John, Jack or Jonas. Is this even possible?

View Complete Post

More Related Resource Links

custom field type works in view properties, but not in list view: 3 parent fields filter child list,


My situation:

A) odd thing is that no matter where I put a stop point in my custom field type, it is NEVER hit when the items are displayed in list view.  Event with <Field Name="CAMLRendering">TRUE</Field> which causes the list to error out, but again no stop point to help me know why.

B) the value of the column in question will be different for every user who views the list, I'm querying a secondary list based on the user's loginName, and two of the fields from the list we're in. 

C) the display is customized based on whether any records were returned and the current DateTime, so possible displays would be "", "! 12/1/2010", and "7/7/2011"

D) and the text displayed links over to a form for them to do their assignment. the link url would be a config setting url + "?[one of the fields form the list we're in]"

My questions:

1) Is it possible for fieldtype code to execute while a list view is being rendered?

2) If not, then should I chase down the path of a content query webpart?  Will it be able to filter on the current users login name?

3) If not on 1 or 2, can you think of any other way to do this beyond creating a custom application page? (need to having filtering and sorting on this page)

Excel 2007 Filter on multiple values

Hi Everyone,How do I use Excel 2007 Pivot Table's label filters/value filters to filter with multiple conditions? for example, I want to get all customers with customer name start with "G" and doesn't include "E" and with measure>100 and measure between 50-60.Regards,George

list view connection filter doesn't work

  I have  a custom display form for documents library with two connected List View WebPart. I am trying to filter documents at the second list view with the value from the first one. Both list views contain data from the same documents library. I have configured the connection, but second list doesn’t display any item, and it doesn’t matter which field I use for filtering. Also  for another document s library’s custom  display form  it work perfect.But there second list view contain data from another documents library. Not the same as at first   case. Any ideas with my issue?

Custom List View - filter blank value



I am creating a custom list view in SPD2010 and am having some problems. I want to have 3 filters (language, country and quarter). I have set these up as ASP drop down lists that auto postback and then I have defined the paramaters and linked them into the list filter.




This works fine and all 3 drop downs filter the list. The only problem I am having is if I want to search just on one column. The way I have it set up in the filter is

Country EQUALS [Country] AND
Language EQUALS [Language] AND
Quarter EQUALS [Quarter]

If I want to show all entries from Germany and not filter on Language and Quarter how do I do this? I have tried adding a "Please Select.." entry at the top of the list and setting the value to nothing but it does not work. I have had to create 3 seperate views but I would love to get these 3 filters working at the same time.

Is there a value in SP that I can use to filter on blank values or not consider the column at all? I have tried using nothing in the value and also tried NULL but neither have worked.

I have been trying to solve this for some time with no luck :( If anyone has any

Filter List Form Field

Hello.  I've customized the Timecard Management template a bit.  The problem I've run into is that the PunchIn form lists all the projects in the Projects list without any filters.  As time goes on, the drop down box on PunchIn has gotten extremely long.  I'd rather not delete Projects and the associated data, but need to filter the drop down box for Projects with Status not equal to "Complete".  Any ideas how to help a nub with this issue?  Using SPD07.  Many thanks!

How To: Filter a link list dropdown field in a form based on Active/Inactive field in the linked li


I need to filter a dropdown field on a form that is linked to another list.  The linked list has a field active/inactive and I only want the active ones to show on the form.

Filter Data View Web Part based on a field



I am trying to filter a data view web part based on a choice made by the end user. I have a lookup field in the Pages list that displays the Title of all pages within that list. I want it so that when an end user selects something from that field that it will filter the list accordingly. Do I need to create a variable, parameter or something of that nature?

Any help is greatly appreciated! Thanks in advance.


Filter document library based on multiple lookup values



I have a very unique requirement for MOSS 2007.
Lets say there is a list of projects; A, B, C, etc.
Then there are phases of the project: Design, Develop, QA, etc.
When the documents are uploaded to a document library, a project and phase is selected at the time of check-in.
I want to create a project page to show project documents by showing documents for each phase in a different web part: eg. Design web part, Develop web part, etc. all bringing documents from the document library.
So far, all good. This can be created by using web parts, views and filters, etc.
Now, I want to create a custom list with Username, Project, Phase. like this:
User1, Project A, Design
User1, Project A, Develop
User1, Project A, QA
User1, Project B, QA

Now, if User1 goes to this project page for Project A - the user sees documents in all 3 phases.
if user1 goes to Project B - the user sees only QA documents.
I will be ok with just showing and hiding web parts completely.
or showing the web parts, but filtering out the documents. either is fine.

I have tried a combination of filters, CAML, etc. but getting values from a custom list to apply the filter is where I am stumped. I want the custom list as it will be easier for the end user to manage permissions for each user for each project for each phas

Dynamic Data Foreign Key Filter - how to limit the # of dropdowns on the list view



I have a visual basic website in VS 2010 framework 4, linx to SQL, with scafolding.... and this dataclass has about 10 foreign key fields, of which all 10 are shown in the list view of the website.  I want the ability to exclude those filters from the list view (or exclude some and keep some), but without eliminating them from the edit forms.  Using <scafoldingcolumn("False")> does the trick to remove them entirely but that will also remove them from the grid/list itself, which I don't want, and remove the column from the edit record views, which I don't want either.

Any help would be great!!!!

Cannot filter a KPI list view



I'm just starting work with KPI in MOSS 2007 recently. Hopefully, I'm on the right forum. Please let me know if otherwise.

So, I've created a new KPI list. Inside that KPI list, I've created several indicators using data from another custom list on the same site. All of these indicators are using "All items" view from that custom list. Next, I've added another indicator from that same custom list but using a different view.

The indicators are working fine. I'm trying to create new view on that KPI list to show me the indicators that I'm interested in. I'm able to create new view based on the default "KPI List" view, but the filter doesn't seem to work. No matter which field or value I specify, the new view always shows all the indicators.

Is that the expected behaviour? I've tried to search online, but didn't see anything that can be of help. I need to create filtered view of the KPI list, because I'm showing these indicators on a web part page as part of a dashboard. For that, I'm using the web part for "Key Performance Indicator" but I don't need to show every single indicators. Only certain indicators will suffice.

One workaround I can think of is to create a separate KPI list and separate my indicators into different lists, but that sounds like an odd workaround/over the top!!!


GridView Multiple Filter AJAX Control

This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

Filter search over multiple text columns


Hi everyone,

I'm working on a library that stores information on various cases. The case table has several columns that contain descriptive strings on what happened in the case. I would like to create a single filter that returns all cases where the search string is found in any of the columns. I've looked at Dynamic Data Filtering, but as far as I can tell, the "Contains" filter only allows you to connect to each column individually. Has anyone tried this?



Issue in Infopath 2007 browser form - cascading dropdown using owssvr.dll filter view


Referring the below link, I created a cascading dropdown. The parent dropdown has sharepoint list as datasource and the child dropdown has xml datasource that points to owssvr.dll filter view. The cascading drop down works fine in preview but throws error after publishing as admin approved form - "form cannot run the specified query" exception when trying to execute xml datasource i.e., when a value is selected in parent dropdown. The security is 'Full Trust". In the event viewer the error message states "401 unauthorised" for the user a/c. the xml data source is an approved udcx file and in central admin, have enabled cross domain for infopath service. I have tried different solution provided in tech forums but issue still exists. Not sure whether Im missing something. Can someone guide me in fixing this issue?

Link Reffered:



Is it possible to filter KPI list in order to display only relevant KPIs


I  have created a KPI list and I want to show sections of the list on various parts of my site, however, I dont seem to be able to filter the list. Has anyone tried this and had any success?

DVWP filter values




I've created a DVWP that pulls data from three lists. I've enabled the filter/group/sort toolbar. Each of the lists has a Person field which I am able to display correctly in the table (using disable-output-escaping="yes"), however, the values in the Filter drop-down still have all the HTML code.  How can I get the values in the filter drop-down to display correctly?



Filter web parts in new form page of a list



I've created 2 custom lists. The 2nd list has a lookup column from the 1st list. In the new form page for this 2nd list, I've added the 1st list as a web part. Now, I want to connect the 2 web parts, but it's not available. Basically, what I wanted is that when I select an item on the lookup column, the webpart containing 1st list would show that item on the same page.

I think I'll need to use Sharepoint Designer to implement something like this, but just wanted to check if anyone has done something like this using browser only.



How to filter Values in a ChoiceField, which is used in different ContentTypes?



i have a Base Content Type which is called eaBaseContentType. In this ContentType i have a Field which is called Document-Type. Its an Choicefield with some List of Values.

My Problem is, that i derive from this Base Content Type 10 other ContentTypes and i have to filter the ChoiceField down. That means, that i have the following structure:


      -->   eaSubContentType1 (Derived from eaBaseContentType)

      -->   eaSubContentType2 (Derived from eaBaseContentType)

      -->   eaSubContentType3 (Derived from eaBaseContentType)

      -->   eaSubContentType4 (Derived from eaBaseContentType)

      -->   eaSubContentType5 (Derived from eaBaseContentType)


The eaBaseContenttype has a ChoiceField. But i need only a Part of the values in the drived ContentTypes. How could i do this? I have tried to put a Column  (called Document-Type) only in the derived ContentTypes and not in the eaBaseContentType, but then i get an error that the Field in the Site Column Collection already exists.

How could i achieve this?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend