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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

How to connect twp web parts on multiple lookup filed basis?

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

Hi,

I have two webparts. One has to fetch column values from List A and the other has to fetch the values from List B. List A and List B has common column "Service". This column is multiple value lookup type in List A and single value lookup type in List B. I have to connect two webparts in such a way that clicking on Service (mutiple value lookup filed) from the first webpart filter the second webpart on this column basis.

As, the first webpart has mutliple values, i am not able to filter on a single value as it is treating the multiple values as a single string.

Can anyone suggest me how to achieve this?

Thanks in advance,

Hema

 




View Complete Post


More Related Resource Links

Quick Note: Connect Web Parts in SharePoint 2010

  
Learn to create and deploy two Web Parts and then connect them so that making in a selection in one displays that selection in the other.

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

Connect multiple lists

  
Hi, I have a list "List1" with column let's say "A". I have 4 more lists List2,List3,List4,List5 with different columns. Once an item is created in List1, another item will be created in all the other lists. My requirement is to connect all these lists some how may be I can use column "A" from List 1. I know look up column works but I guess it is only one way. I need to be able to navigate from one list to another ex. If I use look up column, then I can navigate only one way from List1 to List2. I need to also navigate from List2 item to List1item. Please let me know a possible solution. Thanks in advance. I am using MOSS 2007 standard edition.

Connect multiple lists

  
Hi, I have a list "List1" with column let's say "A". I have 4 more lists List2,List3,List4,List5 with different columns. Once an item is created in List1, another item will be created in all the other lists. My requirement is to connect all these lists some how may be I can use column "A" from List 1. I know look up column works but I guess it is only one way. I need to be able to navigate from one list to another ex. If I use look up column, then I can navigate only one way from List1 to List2. I need to also navigate from List2 item to List1item. Please let me know a possible solution. Thanks in advance.   I am using MOSS 2007 standard edition.

Can multiple users connect simulateously to an offline cube created by SSAS 2008?

  

We have created an offline cube on a network drive from SSAS 2008 and users are able to successfully access this serially using the Excel 2003 cube add-in or Excel 2007, in concert with version 10 driver, but when a user is already connected, the second attempt to connect will get the message :

Connection to <filename> server, <dbname> database, <cubename> cube failed.  OLAP Server error: The following system error occurred:  The process cannot access the file because it is being used by another process. ., File system error: An error occurred while opening the '<filename>' local cube file.

This is regardless of whether users connect specifying read-only and we have found it impossible to connect to a cube if the file has the read-only attribute set.

Is there any way to solve this without users taking copies onto their workstations?

 


MickO2

Common parts in multiple orders - Resultset

  

What I have in this list (SQL Call is below) is a subset of a table with 3 orders (could be more) worth of parts.... I need a summation of what are the common parts (based on Part), and in a seperate query, based on Part and Part_Rev. Using SQL Server 2005 SP3.

SELECT ORDER_ID, PART, PART_REV FROM ORDER_DETAILS
WHERE ORDER_id IN(203,198,205)

Thank You

Paul


Lookup field which allows multiple choice - problem when query with CAML

  

I created one simple list and added one column - lookup - I've chosen some source list and field, then marked "Allow multiple choice". I created new item in that list, by adding more than one valie to that coulm.

The problem is, when I use CAML query, that column has such values:

value1;#2;#value2;#3;#value3

and it's suppose to be like this:

1;#value1;#2;#value2;#3;#value3

do You have any idea, why it doesn't query first ID?


Sharepoint2010:Upload multiple document and connect to outlook :owssupp.dll & stssync

  

My first question went un-answered but I solved in after some midnights, now this is my second question, I am beginning to think SharePoint2010 is fantastic but is lacking in real support.

I am using SharePoint2010 , accessing from internet on Windows7(64bit) and Office 2010(64bit) notebook, While trying to access iver internet, Multiple upload of documents and Connect to Outlook are greyed out even after placing the URL in the trusted sites. Afte rmuch digging up it points to OWSSUPP.DLL and STSSYNC, which are supposed to help in these function. In Office 2010 I can't find this DLL and IE8 (64bit) does not have the STSSYNC active X loaded in my managed-add-in nor did it prompt me to download this active x.

The big question here is can some one help be shed light on this, what's the point if all on OWSSUPP.DLL are talking on Office 2007 when Office 2010 is in the market.


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

Lookup fileds with allow multiple values option enabled are separated by ;# in export spreadsheet

  

The lookup fields with allow multiple options enabled displays parent listitem id separated by ";#" when exporting to spreadsheet. I need to remove the #and the parent list item id from the spreadsheet. how to achieve that?

Any suggestions?


multiple web service requests to an SSL secured service (HTTP CONNECT)

  

I'm working on an app which makes multiple SSL requests to a web service. The service has the certificate, there are no client certificates in use. If I look at the messages in Fiddler, it looks like there is an HTTP CONNECT for every request, which gets the servers public key and then makes the actual SSL request. 

Do I need to do something in the client proxy code to cache the servers certificate to avoid the HTTP CONNECT call every time?

Thanks, casey


How to set multiple value for a lookup field with powershell script?

  

I have a list that has a lookup column and can have multiple values.  I know how to set value to this field with powershell script. I need to know how to set multiple values to this field. 

Also, how can I create this field with powershell script?

Thanks and regards,

 


Filter document library based on multiple lookup values

  

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

Lookup set retuen multiple fields

  
I am trying to return multiple column fields using a lookupset but it seems like it can only return a single field at a time. What is the alternative or how can i change my code to return multiple fields.
=Join(LookupSet(Fields!contactid.Value, Fields!customerid.Value, Fields!new_mailname.value, "relationship"),",")

Display / Show Multiple Web Parts

  

Currently i trying to do display / hide multiple web parts (content query) based on user click. I have created 5 content query, on default it will show only 1 web part and others web part will be "hidden". When user click another selection, it will show the correct web part information and hide others. I will really appreciate if anyone could give me the idea, guideline to perform this task.

Roughly i have an idea which is using getElementByID to control the webpart ID however i did not try it yet . I also go through below link however i still cant understand well how it works. Thank you.

Ref: Show/Hide Multiple Web Parts by Bryon Wyle

http://wyly.wordpress.com/2009/05/22/showhide-multiple-web-parts/

 


Connect to Outlook a Task list that has Tasks with Multiple users assigned

  

Using MOSS 2007 SP2 and Outlook 2007 SP2 

I go to a task list that has multiple users assigned to a task.

I setup the connect to outlook for this list, and in outlook I only see the tasks that have a single user assigned.

None of the multiple user assigned tasks are visable, is this how it is supposed to work?

 

 


Multiple database support with Entity Framework

  
One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.
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