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


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

Traversing Lookup Columns in a SharePoint View

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :SharePoint
 
I have a list with a lookup columns that references another list. This list, in turn, has a lookup column that references a third list. This represents a Child->Parent->Grandparent relationship.  I have a view of the child list and I want to filter the items based on a column in the grandparent list.  I know I can do this in code using LINQ to SharePoint, but is there a no-code solution? The Content Query web part infers that it can do this but I didn't see a way to implement this. Does anyone know of a way to accomplish this in SharePoint Designer or the SharePoint UI?


View Complete Post


More Related Resource Links

How to create scrolling table for columns in a SharePoint Designer Data View

  

I have a fairly complex SharePoint Designer 2007 Data View they have added two more requirements.

1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place.  This is only one list not two, and because of some other requirements I have it must remain to be just one list.

2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.

The first requirement is more important than the second, but preferrably I need to do both.

I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?

I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.

So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/  or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png

I failed to mention that 3/4 of the columns are HTML Calculated fields wh

Lookup columns in a SharePoint Custom list

  
Hi, I would like to know the maximum lookup columns we can create in a SharePoint Custom list. Thanks and regards, Usha   

SharePoint 2010 SPSiteDataQuery with Lookup additional columns.

  

Hello

I am trying to use SPSiteDataQuery to collect data across different sites. The query seems to fail when I add Lookup additional data columns. I mean when we create a lookup column, sharepoint 2010 allows us to get data from additional columns from the lookup list. When I try to include these columns SPSiteDataQuery is failing. This is the viewfields that I am using.

"<FieldRef Name='ID' Nullable='True'/><FieldRef Name='Lookup' /><FieldRef Name='Lookup_x003a_Title'/><FieldRef Name='LinkTitle' Nullable='True'/><FieldRef Name='Created' Nullable='True'/><FieldRef Name='Modified' Nullable='True'/><FieldRef Name='ID' Nullable='True'/>"

In here the Lookup_x003a_Title (displayname : Lookup:Title) is the column that bring data from the Title column ofthe lookup list.

Any help is greatly appreciated. The query works fine without Lookup:Title column.

Thanks

Vijay


SharePoint lookup site columns and Word Content Controls

  
I discovered that when you bind lookup columns in SharePoint to a Content Type that in turn pushed these properties to the document, the value actually stored is the ID and not the text that is displayed. What is the correct way to use such site columns to enable users to select the data they want to be associated with a document and then to have the display values be populated in the Content Controls?

Entity Data Model and database view returning the same columns as there are in a table

  

When adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined. 

How do I do something similar for a view?


I mean assuming I have a view like this

CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...

(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.


var foos = myDB.FilteredFoos.Include("Bar").ToList();

foreach (Foo foo in foos) { ...


Thanks, Jenda


Issue with opening SharePoint library in Windows Explorer view

  
I am having trouble opening a document library in Windows Explorer view. The portal is MOSS 2007. I have installed Office 2007 and IE7 on my computer. The error that I get is
"Documents in this folder are not available. The folder may have been moved or deleted, or network problems may be preventing a connection to the server."

Sharepoint 2007 View Problem

  
I have a document library in Sharepoint 2007 in which I have seet up a number of different views so that the users who work with the information in that library can filter down to the specific area that they work with.  The view itself works great, and they are able to see their data quite easily.  The problem comes when they actually go in and edit any of the items.  Unlike most software in the civilized world for the past 30 years, the user is not returned to the view that they were working with, but to the defult view.  This means that any task where they are required to do many edits at a time becomes a frustrating nightmare and waste of time.  Is there any setting I can change, or anything else at all that I can do to give my users a little relief by making the site navigation such that they are returned after an edit to the same view that they were in before the edit?  Ideally, it would be nice if the same scroll position within the view were returned as well, but I suspect that I may be asking for too much by pushing that issue.  HELP! HELP!  Any and all constructive assistance is appreciated.

Creating List Definitions with Custom List Columns for SharePoint Server 2007

  
Learn to use Visual Studio 2008 Extensions for Windows SharePoint Services to create a SharePoint list definition that implements custom list columns.

SharePoint permission to view draft pages

  

Hi,

I would like to create a new permission in sharepoint 2007 where all the people having this permission should be able to view the draft pages but they should not have right to edit that page or publish that page

can any one please let me know how to create a new permission which has a right to view draft pages but not edit\publish the page.


THANKS in advance u can reach me on rajesh.batchu@hotmail.com

Datasheet view lookup column issue

  

When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.

http://support.microsoft.com/kb/948952

Any ideas how to get this resolved?


DVWP connections with multi-select lookup columns

  
I have a question concerning the Data View Web Part using SharePoint Designer 2007.   I have two list (A and B). List A has a lookup column (called B-items) with multiple selections to items in List B(using the Title column from B).   I create a web part page and insert a data view of using List A. I create another data view with data from List B. Next, I make a Web Part Connection between the two data views with A passing B-items column as parameter to List B data view. I then create a filter on the List B data view with a comparison of List B’s Title column equal to the parameter of List A’s B-items value when a user selects an item from List A data view. The problem is nothing appears in List B’s data view.   When I try the reverse of the above scenario it works fine.     I understand that this is properly functionality, but is there a way to achieve my first scenario? If so, how can it be accomplished?   I have looked through the web for help and found the answer here http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/749b7477-f37f-4724-94b3-b6ace770e73a seems to be what I’m looking for. However, I am unsure how to implement his code into the web part page.   I am a worse than a novice with xsl so if anyone gives an example I would greatly appreciate step by step on what code is needed a

Sharepoint and IIS/Windows Event Logs in a single view

  
Hi - I'm coinsidering addng sharepoint log reading capabilities into an application I've built for reading windows and IIS logs (for more info http://logenvy.com). I know there are quite a few applications capable of reading sharepoint logs (a number are listed here http://stackoverflow.com/questions/781179/sharepoint-2007-log-viewer). Does anyone think the capability to analyse windows and IIS logs alongside sharepoint logs would be useful, or have any logging requirements not well met by the current set of tools? I'm especially keen to explore useful/interesting data visualizations on top of data logs.

How to get "Current Date" on SharePoint Designer for Invoice Ageing Data View Report??

  
Hi Experts, I would like to know how can i get/show "Current Date" in SharePoint Designer ?? Any good tutorial ? FYI, I need this "Current Date" for my Ageing Data View Report, Purpose To offset with "Invoice Receive Date" to get total days of payment payable for the invoice. Please assists, Thanks

SharePoint 2010 datasheet view 64 bit vs 32 bit

  
I think that the Windows 7 64 bit I have is causing problems between My Office Suite (32 bit) and my IE 8 is (64 bit). I am not able to edit in datasheet view and my upload multiple documents is greyed out? Any help would be greatly appreciated! Thanks!

Problem while retrieving data from a lookup column from sharepoint linq.

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

scrollbar is not showing for sharepoint list with group by view

  
Hi, have created a Share point 2007 list having a huge data. I have created a group by view by grouping the data with category. My requirement is to show the data as web part on a page. When i did so, while expanding the group inside the web part, the web part is expanding. I want to keep the height and width of the web part fixed so that the layout of the page will not be ugly looking. But though I am putting the option for fixed height and width in the web part setting but I am not able to see the scroll bars. Where as I can see the height and width are fixed but could see a few data instead of all the data with scroll bar.   Please advice me if there is any solution or workaround.Deeptyranjan
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