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

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

How to use DVWP to filter multiple columns in a document library

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

I am not new to SP, but newer to developing in SP, so I need some help please.

I am attempting to convert my company away from nested folders on SP. Elsewhere I saw a way to add multiple custom columns to a document library and then use a different web part (I thought the Form Web Part, but that only lets you filter on one column at a time) to filter the document library using those columns.

Ex: I have three columns:

* Market - with the checkbox choices being Employer, Public, Payer, and GovEduLab. A document could be a part of all, some or one of those markets.
* Product - with the checkbox choices being Care Solutions and Behavioral Solutions. A document could be a part of all, some or one of those markets.
* Process - again, checkbox choices being Account Planning, Commissions, Contracts, etc. And again, the doucment could be a part of all, some or one of those markets.

I want to create something that will allow the user to use some kind of "form" to filter find any document that is a Public-Care Solutions-Contract document and only show thsoe documents in the library.

This is what I have been trying to make it look like, but I am not tied to this:


View Complete Post

More Related Resource Links

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

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?



Document Library "export to spreadsheet" doesn't export all columns in Excel 2003

Hi, we are working with MOSS 2007, Infopath Forms Services, KPIs and Excel 2003. There is a view for some data of the Infopath forms which has to be exported to Excel by our users, but some columns are not exported - without any error message. If I try to export it to Excel 2007 everything is exported as expected, but our users have to use Excel 2003. Any idea?

Unable to create columns in document library after applying custom master page to site

Hi, I have applied a custom master page to a site.There is a document library in it. I am unable to add columns in it or change the default view.Nothing happens when I click on OK butoon after making my changes. However the columns are created/default view is changed when I apply the default master page. Guess I am missing some TagPrefix or sharepoint control on master page.I had solved this problem earlier in this way but don't remeber it now. Can anyone help?

Unable to filter the "E-mail To" field in email enabled document library

Hi, We have setup a few email enabled docuement libraries to store emails relating to project work. Is there a way to make the "E-mail To" field in the library be filtered? It is greyed out and doesnt give you the option. The "E-mail From" and "E-mail Subject" are able to have a filter applied to them but for some reason the "E-mail To" field wont let you filter the content. The probelm is that there are over 500 files in the library and the easiest way to find messages is to be able ot filter this column in the library if it is at all possible.

InfoPath 2007 - Publishing Creates multiple columns on SharePoint Form Library (GUIDS apparently are

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

Altering in-document form layout for Document Library Columns



My users need to add metadata to documents they check out of a Document Library while they are in the document. That works fine (the forms appear at the top of the Word Document, underneath the task bar). However, the layout of the forms is kind of bad. Is there a way to redesign the forms in the top of a word document so that they look better?



Adding multiple users to a document library column by web service


I'm attempting to create some VB code to call a SharePoint Web Service to add a document and associated metadata to a document library. I can successfully add metadata to a text column but I'm having some problems getting multiple entries into a column which is specified to take multiple users (and does so when they are added manually) although I can get a single user in using the following snippet.

Dim info2 As MySharePoint.FieldInformation = New MySharePoint.FieldInformation()
info2.DisplayName = "Authors"
info2.InternalName = "Authors"
info2.Type = MySharePoint.FieldType.User
info2.Value = "1"

I'm hoping that someone will be able to advise me of the approach or syntax necessary to add multiple users to this Authors column e.g. Users 1 and 74. I note that

info2.Value = "1,74" or info2.Value = "1;74"

don't appear to work.

filter search results to specific document library


Hi all.  I have a sharepoint 2007 subsite, which is a small part of a large corporate sharepoint 2007 system.  I only have admin rights on my chunk.

I would like to limit a search to a specific document library within my subsite, and further would like the search results to return additional non-standard meta-data from this library.

Is this something that I can do without creating a new search scope? 

MOSS 2007 Strange Problem with edit forms, content types and document library columns


I'm having a strange problem and have not been able to track down any useful answers over google.

I inherited a SharePoint site that I am now making some changes to.

I am having problems with one document library.  We had custom edit forms on this document library, which I was finding a pain to maintain so I reset them back to the site definition.  This edit form now shows only those fields that are associated with the Document content type (the only content type - I've deleted the others) on the document library.  There are other columns on this document library that are NOT associated with the content type that I would like to show on the edit form but they are not available when I try to add them to the content type via Settings > Document Content Type > Add from existing site or list columns.  The select columns from drop down is set to List Columns.  The Additional Authors column is just not there.

I CAN see this field on the all items view for the document library, it is there and populated with data.

Setting the Allow Managed content types radio button to NO does not have any impact on which fields are visible on the form- I still see those same fields that have been associated with the Document content type.

Has anyone else seen this or does anyone have any thoughts?? 

They will be muc

Document Library Missing Columns in Edit Properties

Hi, I'm having an issue with a specific Site Collection.  The issue is that some of the columns do not show up when you go to the Edit Properites page, or when the user creates a new document.  The items can be edited when opened in a data sheet, but the users would like to be able to edit them on the Edit Properties page.  They say they haven't made any changes, but this has happened at least 3 times with differenct document libraries on this specific site.  Has anyone else ever dealt with this?  Anyone got a solution?  Let me know if more info is needed.  Thanks.

Why is Sharepoint 2010 standard search no searching within Document library columns



Environment : SharePoint 2010 Enterprise version, using regular search and NOT Fast Search

Standard search is configured and running succesfully and returns results by searching in documents and columns of lists\ calendars and everything else except for Document librarie's columns may it be text or lookup datatype, any clue?



Filter Form Library View using promoted columns from InfoPath

I have a form that requires two levels of approval. This is published to a form library on SharePoint 2007. I only want users to see their own forms as there are monetary values involved. I can achieve this using the view filter “Created by” & “Modified by” = [Me], however the line approvers can only see the forms after they have interacted with them. Once the next person in the workflow edits, they cannot see the form.

I have tried using columns I promoted where I have stored the username of the approvers and using the [Me] filter, I get a “Filter value is not a valid text string”. I created two more calculated columns in SharePoint making them equal to my InfoPath fields, and I still get the same error.

Can anyone tell me how I can set a filter so that these line managers can at all times see any forms that have required their approval?

Many thanks in advance.

External Data Fields in a Word Template saved as a content type in a document library with multiple


I have created a Word Template for a Document Library that has an External Data Column in it of Client Name which also adds Client Address1, Client Address2, Client City, Client State, & Client Zip.  Now this works fine for a Document library with that template as the Template.dotx file. 

I want to be able to make a bunch of Templates and have them all as Content Types in one Library.  When I do this I cannot get the External Data Quick Parts to work.

Anyone have any ideas?

Filter document library by page title


I want to create a page that displays a range of information for a project, the page title will be the project name. All projects have a single folder in a document library on the same site, again, the folder name is the project name. Using the page title (i.e. project name) I want a web part on the project page to display the folder for the relevant project. Unfortunately I am running SPF2010 and as such do not have the CQWP.

I thought I could use another web part that contains the project name to connect to a dataview web part of the library and subsequently display the folder. However, this would require the user to add the project name in a HTML form web part each time they navigate to the page. Any ideas on how I can have the filter applied automatically when the page is selected? 

Apologies if my explanation is not clear...

failed to upload multiple files to a document library!


I have a document library. I have upload a lots of files by upload multiple documents function several days ago. When I tried to upload some files today. It always failed if I drag a folder into the upload multiple documents dialog.

Drag a folder with any number of files in it to the upload multiple documents dialog. Failed.
Drag files into the upload multiple documents dialog. Sucess.
Create a folder manually, then upload files into the new folder. success.

Anybody have some clues for this problem. Why today I always failed to upload files when I drag a folder?

Thanks very much.

Passing Calculated Columns from Sharepoint into Word Document Library Template


Hi all...

Another noob question.  I have been able to figure out how to pass single line text, date, etc. data from a Sharepoint List into a Word Template, but I am still trying to figure out how to pass a calculated column.  Is there a workaround?


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