change display style for link column type in content query webpart

Question

I have some questions about content query web part with sharepoint 2013

I use the content query to filter a list.

This list has a column type link with some http links.

when I display it with the content query I got something like "http://XYZ.xxx, friendly name".

I would like to change that to friendly name only with href to the http column value as a the link.

How can I achive that?

I already had a look into itemstyle template but not easy to deal with, just be able to find the bullet template i'm using but not able to change anything -(

any help could be usefull.

Many thank you!

Answer 1

There are a couple of options:

• If it is a links list, you can use the notes field as display name

  Link: "URL [Custom Columns];"

  Title: "Notes;"

  Description: leave empty

  Template: Image on the Left

• If it is a custom list with a hyperlink field

  Link: Link_Field_Name

  Title/Description: leave empty

  Template: Image on the Left

• Create your own template

  You can add a new custom template to the list (dropdown) of available templates:

  1. Open Style Library/ItemStyle.xsl
  2. Paste the code below right above the "Default" template (instead of {$SafeLinkUrl}, which takes us to the display form, we will use the url from the field itself)
  3. Setup your webpart to use the new template

The code:

<xsl:template name="MyCustomTemplate" match="Row[@Style='MyCustomTemplate']" mode="itemstyle">
        <xsl:variable name="SafeLinkUrl">
            <xsl:call-template name="OuterTemplate.GetSafeLink">
                <xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>
            </xsl:call-template>
        </xsl:variable>
        <xsl:variable name="DisplayTitle">
            <xsl:call-template name="OuterTemplate.GetTitle">
                <xsl:with-param name="Title" select="@Title"/>
                <xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>
            </xsl:call-template>
        </xsl:variable>
        <xsl:variable name="TheLink">
            <xsl:value-of select="substring-before($DisplayTitle,',')"/>
        </xsl:variable>
        <div class="item link-item">
            <xsl:call-template name="OuterTemplate.CallPresenceStatusIconTemplate"/>
            <a href="{$TheLink}" title="{@LinkToolTip}">
              <xsl:if test="$ItemsHaveStreams = 'True'">
                <xsl:attribute name="onclick">
                  <xsl:value-of select="@OnClickForWebRendering"/>
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="$ItemsHaveStreams != 'True' and @OpenInNewWindow = 'True'">
                <xsl:attribute name="onclick">
                  <xsl:value-of disable-output-escaping="yes" select="$OnClickTargetAttribute"/>
                </xsl:attribute>
              </xsl:if>
              <xsl:value-of select="substring-after($DisplayTitle,',')"/>
            </a>
            <div class="description">
                <xsl:value-of select="@Description" />
            </div>
        </div>
</xsl:template>

The only relevant part is:

substring-after($DisplayTitle,',')