How to Display the Site Title and Site URL in Search Results

Recently I was restyling the search results, and one of the expectations was to display a hyperlink to the site of origin of the result.

Adding the site title of the returned results is very easy, this can be retrieved from the metadata property “SiteTitle”. The web URL is a bit more difficult. My first thought was to check the crawled properties, but there is no reference for the web URL, only a reference for the site collection URL called: “ows_SPSiteURL”.

My second thought was to some XSL manipulation, and this was the best approach.

The final result will be: {{< caption-new “/uploads/2011/05/052711_1345_HowtoDispla1.png” “Search Result with Site Reference” “data

1. Adding Site Title column references to the fetched properties of the Core Result Web Part.
2. Editing the XSLT from the Core Result Web Part. In the following sections I will go deeper into the two steps.

Adding column references (Fetched Properties)

Fetched Properties are used to let SharePoint know which metadata should be retrieved for each result.

The column that needs to be added is: “SiteTitle”.

To add these columns go to your search result page or the page where you are using the core search web part.

• Turn the page in edit mode;
• Edit the “Search Core Results” web part;
• Open the “Display Properties” section; {{< caption-new “/uploads/2011/05/052711_1345_HowtoDispla2.png” “Display Properties Section” “data
  /jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAAAoAAAAPCAIAAABSnclZAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABQElEQVR4nDWQ25KCMBBE8//fZu2WIHJJAiEEg3LLHYKoWyB7HuZlurtmGvR9V9csjpOK0jzHWQZLSoWUYgfE8TXLIIYoSzOEEEaQN/dlea47IArDIAij6MJ5gxHECH4+n/f7/dkBOUZlSWvGbrcbIaVzzs/++Vx2zRv8/PzKHaWUlFIrJZWcJne4q6oyWmtjlNZCbCrn3ChFPwxKK1BRWhRFnud1fWOMEUIopcbYdV2f6wpOpxOldOg3hqHvu65tW2vtEY4xttZ67+d//LJYa7/HA940h3Uc74/HKIT3Xhvzeu3rMAjyoiBFwXlTM9a1nbV2nucjPDifp2map8k5N23TGq2dc0f49qyUoxBt30sphRTDMDwerTbbdSCJkzRJCSEQwiRJOedbcd4f4ddrlMZJHMUIoTTZpGF4YRX7Nv8HVUOfuwGycT0AAAAASUVORK5CYII=” “194” “300” >}}
• Add the following column to the “Fetched Properties”;
• Click “Ok”. The full “Fetched Properties” XML is the following:

1
<Columns>
2
  <Column Name="WorkId"/>
3
  <Column Name="Rank"/>
4
  <Column Name="Title"/>
5
  <Column Name="Author"/>
6
  <Column Name="Size"/>
7
  <Column Name="Path"/>
8
  <Column Name="Description"/>
9
  <Column Name="Write"/>
10
  <Column Name="SiteName"/>
11
  <Column Name="CollapsingStatus"/>
12
  <Column Name="HitHighlightedSummary"/>
13
  <Column Name="HitHighlightedProperties"/>
14
  <Column Name="ContentClass"/>
15
  <Column Name="IsDocument"/>
16
  <Column Name="ServerRedirectedURL"/>
17
  <Column Name="SiteTitle"/>
18
</Columns>

Search result XSL styling

Now that the” SiteTitle” column is added as to the Fetched Properties, you can edit the Search result style.

• Edit the “Search Core Results” web part;
• Under the “Display Properties” section, click on the “XSL Editor” button; {{< caption-new “/uploads/2011/05/052711_1345_HowtoDispla3.png” “XSL Editor” “data
  /jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAAAoAAAADCAIAAAAlXwkiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAZklEQVR4nAXB6wpAMBgA0L3/I7lEySXGaiOXRjJmy6X94cdXi3MQ7zjvRkZqJY/HPLe+1apOfclFmtOgaRiqAuMsr3DZsoYRSjDpmz6NEjEL1NY08JzQd33XybNYbftnP3jBgoUXfg4aTWA91neBAAAAAElFTkSuQmCC” “179” “55” >}}
• Copy the content of the XSL Editor to the text editor of your choice;
• Add the following two XSL templates before the </xsl
  > closing tag;

1
<xsl:template name="SPWebUrl">
2
  <xsl:param name="siteUrl" />
3
  <xsl:param name="contentclass" />
4

5
  <xsl:choose>
6
    <!-- Check the content class to see if it is a document -->
7
    <xsl:when test="$contentclass='STS_ListItem_DocumentLibrary'">
8
      <!-- Get Document Library Url Name -->
9
      <xsl:variable name="DocLib">
10
        <xsl:call-template name="StripSlash">
11
          <xsl:with-param name="text" select="$siteUrl"/>
12
        </xsl:call-template>
13
      </xsl:variable>
14

15
      <!-- Remove the document library from the url -->
16
      <xsl:variable name="SPWebURLString" select="substring-before(concat($siteUrl, '/'), concat('/', concat($DocLib, '/')))" />
17

18
      <xsl:value-of select="$SPWebURLString"/>
19
    </xsl:when>
20
    <xsl:otherwise>
21
      <!-- Get List Url Name -->
22
      <xsl:variable name="ListUrl">
23
        <xsl:call-template name="StripSlash">
24
          <xsl:with-param name="text" select="$siteUrl"/>
25
        </xsl:call-template>
26
      </xsl:variable>
27
      <!-- Remove the list name from the url -->
28
      <xsl:variable name="urlLists" select="substring-before(concat($siteUrl, '/'), concat('/', concat($ListUrl, '/')))" />
29
      <!-- Remove Lists from the url -->
30
      <xsl:variable name="Lists">
31
        <xsl:call-template name="StripSlash">
32
          <xsl:with-param name="text" select="$urlLists"/>
33
        </xsl:call-template>
34
      </xsl:variable>
35
      <xsl:variable name="SPWebURLString" select="substring-before(concat($urlLists, '/'), concat('/', concat($Lists, '/')))" />
36

37
      <xsl:value-of select="$SPWebURLString"/>
38
    </xsl:otherwise>
39
</xsl:choose>
40
</xsl:template>
41

42
<xsl:template name="StripSlash">
43
  <xsl:param name="text"/>
44
  <xsl:choose>
45
    <xsl:when test="contains($text, '/')">
46
      <xsl:call-template name="StripSlash">
47
        <xsl:with-param name="text" select="substring-after($text, '/')"/>
48
      </xsl:call-template>
49
    </xsl:when>
50
    <xsl:otherwise>
51
      <xsl:value-of select="$text"/>
52
    </xsl:otherwise>
53
  </xsl:choose>
54
</xsl:template>

• The next step is to add the following piece of code somewhere inside the “Results” template.

1
<a>
2
  <xsl:attribute name="href">
3
    <xsl:call-template name="SPWebUrl">
4
      <xsl:with-param name="siteUrl" select="sitename" />
5
      <xsl:with-param name="contentclass" select="contentclass" />
6
    </xsl:call-template>
7
  </xsl:attribute>
8
  <xsl:value-of select="sitetitle" />
9
</a>

• Click “OK” and save the page.

Result

Each search result contains the site hyperlink (depending on the location in the result template). {{< caption-new “/uploads/2011/05/052711_1345_HowtoDispla4.png” “Final Result” “data