StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Took me some time ... I was about to give up but continued nevertheless :)</p> <p>The drawback of the key function is that the key generated will always be for the entire xml. Hence you should concatenate additional information in your key to make it more specific. In the e.g. below, I am concatenating the position of records node, so that I get keys for distinct surnames per records.</p> <p>Here's the xslt:</p> <pre><code><?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"> <xsl:output method="html" indent="yes"/> <xsl:key name="distinct-surname" match="contact" use="concat(generate-id(..), '|', surname)"/> <xsl:template match="records"> <xsl:for-each select="contact[generate-id() = generate-id(key('distinct-surname', concat(generate-id(..), '|', surname))[1])]"> <xsl:sort select="surname" /> <xsl:value-of select="surname" />,<br /> <xsl:for-each select="key('distinct-surname', concat(generate-id(..), '|', surname))"> <xsl:sort select="forename" /> <xsl:value-of select="forename" /> (<xsl:value-of select="title" />)<br /> </xsl:for-each> </xsl:for-each> </xsl:template> </xsl:stylesheet> </code></pre> <p>This is the result:</p> <pre><code>Jones, Amy (Dr) Anne (Ms) Indy (Dr) Smith, John (Mr) Mary (Mrs) Peter (Mr) Jones, Harry (Dr) Mandy (Dr) Sally (Ms) Smith, Elizabeth (Mrs) George (Mr) James (Mr) </code></pre> <p>Please note that the result is sorted on the forenames too. If you don't want to sort it on forenames, you need to remove the line <code><xsl:sort select="forename" /></code></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload