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


Top 5 Contributors of the Month
sivanagamahesh
Post New Web Links

Filter document library based on multiple lookup values

Posted By:      Posted Date: November 20, 2010    Points: 0   Category :SharePoint
 

Hello,

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


View Complete Post


More Related Resource Links

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

  

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:

<br

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

MOSS 2007: list column that lookup to multiple documents stored in doc library

  
Hi All, I'm trying to understand how to customise MOSS to achieve the following: I need to lookup from a list to multiple documents stored in a documetn library. Example: - List item 1 --------> Lookup to Doc 2                   --------> Lookup to Doc 5 - List item 2 --------> Lookup to Doc 3                   --------> Lookup to Doc 5                   --------> Lookup to Doc 8 - List item 3 --------> Lookup to Doc 1 How can I achieve this? is it possible that in the lookup I have a "search" option? Thanks all Vit

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

  
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?

Infopath 2007 Repeating Table - Multiple Value Column Text - Hiding Rows based on Column text values

  
Infopath 2007 browser based form Full Trust Example: I have a repeating table (FruitChoice) that has multiple columns. Both drop down list point to sharepoint list data sources. Choose your tree ft. drop down list – 6Ft Choose your Department drop down list - 103 This repeating table is conditional on the drop down values. This works great. Trees     Fruit       Cost   Date Ordered    Date Delivery Department 6Ft        Peaches                                                        103 3Ft        Apples                                                          102 3Ft        Peaches         &

List lookup to document library not showing folder names

  
Hi all, I've got a Sharepoint List, which has a lookup field to a Document Library on the same site. That document library library is populated with several folders, each with several Word documents within. I want my lookup (in the List) to only display the top level folders in the document library. I managed to do that in my test environment. But in my production environment doesn't list the folder names. I've compared the settings in the two and they look identical. What could be wrong, and how to I fix it so that the folder names appear? I'm using SharePoint 2007. Thanks in advance for the 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.

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? 


Is there a way to query entity based on multiple filter criteria? WCF Data Services, Linq to Entiti

  

Instead of:

DW_CMSOPEN dwc = new DW_CMSOPEN(new Uri("http://acctdev02/WCFDataService/EmployeeService.svc"));

dwc.Credentials = System.Net.CredentialCache.DefaultCredentials;

var employees = from emp in dwc.Employees 
             where emp.DEPT == "123"
             select emp;

I'd like the linq query to resemble:

var employees = from emp in dwc.Employees
              where emp.DEPT // in {"123", "456", etc}
              select emp;

Default Column Values in a Document Library (SP2010) do not show up in word 2010 until you save and

  

when you create a document in a SP 2010 document library (of a particular content type, by clicking new, letter (content type name) in sharepoint for example) which has default values set on in in the library (set by using library settings -> change default column values), the default values do not show up until you create the document , save it and reopen it again.  Is this a bug or by design.  If it is by design, it is horrible since if some of the column default values are mandatory in the content type then you actually have to type them in before you could possibly save the file which defeats the whole point of having default column values.  Also it is tremendously clunky for a user to have to create file, save it , close it, and reopen it just to view the default metadata in the document information panel that is supposed to be there.

Anyone have any thoughts/solutions to this problem?


krd

How to Programmatically Upload the files based on the current location in the document library?

  

how can programmatically to upload a file to document library based on the current location for example when i was inside the subfolders and click on the custom button in ribbon it should upload file to current location entered to document library not hardcoding the subfolders name 

Thanks in advance


Custom Columns - Fill values based on value selected in a lookup column

  

Hello,

I am working with Sharepoint 2007. I have a list of 130 buildings located in six different cities and three different provinces. I imported this list from an Excel spreadsheet. I also have a document library that contains various files associated with these buildings. I've added a custom column to the document library that contains a lookup field to the name of each building. I also have two additional custom columns that have the city and province. What I would like to accomplish is to have the city and province columns automatically be set based on the name of the building selected, such that these values are taken from the same row of this list as the building name.

Hopefully my question makes sense.

Thank you, James


Inconsistent data with DateTime values in Word Document Library

  

Hi,

I am new to SharePoint (2010), and my company has recently migrated a Document Library from a different Content Management System. The Doc. Lib has been set up with Content Types and custom Word (2010) Templates to provide a specific structure to the documents. There is a requirement that the Metadata Columns be embedded into the content of the Word Documents, which we have done. However, we are an international company, so we are spread through several time zones.

Two of the fields in the documents are date-only datetime fields, but these fields must contain non-time zone aware dates. In other words, regardless of which timezone the document was created in or added to SharePoint, all users world-wide must see the same date.

When we create the documents by using the "New Document" menu in SharePoint, and fill in the Document Information Panel in Word, the dates work as required. However, if we use the "Upload Document" option, and then fill in the properties in the Default Edit List window, then the dates are time-zone aware, and users in an earlier (further west) time zone see the date as one day earlier.

After some investigation, it seems that Word stores the dates in the format yyyy-mm-dd hh:mm:ssz, with no offset information, and SharePoint then doesn't apply an offset when displaying/storing the data. However, when

SPD Workflow Associated with a Document Library Deletes all Date Values

  

A client has encountered an issue where they created an SPD workflow, associated with a document library, set it to start manually,  that updates one of the metadata columns using the "Set Field in Current Item" activity.  Once that step completes all the date values in the metadata columns are missing.

Upon further inspection, we determined that this is only occurring for office documents.  It deleted the dates for word and excel documents and did not for text and pdf documents.

We are able to duplicate ths on 2 different servers that are both on service pack 2.

We have tried different version settings on the document library and making the date metadata columns required.  No luck.

To recreate this issue:

1.  Create a new document library and added additional metadata columns to it.  Make some of these columns dates. 

2.  Create a new SPD workflow associated with the newly created document library 

3.  Add a "Set Field in Current Item" activity to the workflow and set one of the non date columns to a different value.

4.  Upload a word document and make sure to fill out the date fields.

5.  Kick off the workflow manually.

6.  Once the workflow

InfoPath: Copying values from a multiple-selection lookup (secondary data connection) to a multiple-

  
Trying to use "Set Field Value" action in InfoPath to set values in a multiple selection lookup field. Does not not seem to be possible. Has anyone achieved this?
Iko

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?


Categories: 
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