I recently banged my head against this one. I wanted a list of past meetings and another list for upcoming meetings in my meetings workspace. The calendar is picked up from the parent site using a DataFormWebPart and the “Connect to another library” function. This was all well and good, however, I needed the workspace url to link to the other meeting workspaces. With the list connected there is a field in the data source named Workspace, but that’s a boolean and there is no url to be found. Looking at the Xpath in SharePoint Designer for that field it points to @WorkspaceLink. The trick is to add the property “IncludeHidden” to the SPDataSource object for the web part and find the url by selecting @Workspace.

sharepoint-designer-errormsg
Unfortunately, SharePoint Designer will throw an error at you for doing this when the list is not located in the same site as your webpart. But the end result in SharePoint will be glorius.

Here’s an example of how to display a link:

<a href="{substring-before(@Workspace, ',')}" title="{@Title}">
    <xsl:value-of select="ddwrt:FormatDateTime(string(@EventDate) ,1033 ,'M/d/yyyy ')"/>
</a>

past-upcoming-meetings
Nice, huh?

Related posts