Grouping with Multiple Dates

gaza165 · September 27th, 2010, 03:47 PM

Code:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:key name="date" match="date" use="." />
<xsl:template match="events">

<html>
<body>

     <xsl:for-each select="date[count(. | key('date', .)[1]) = 1]">
		<xsl:sort select="." />
		<h2><xsl:value-of select="." /></h2>
		<xsl:for-each select="key('date', .)">
			<p><xsl:value-of select="../title" /></p>
		</xsl:for-each>
	</xsl:for-each>

</body>
</html>

</xsl:template>
</xsl:stylesheet>

this code outputs nothing...

Martin Honnen · September 28th, 2010, 06:57 AM

Use
for-each select="event/date[count(. | key('date', .)[1]) = 1]"
instead of what you have.
And be aware that sorting dates in the format yyyy-mm-dd is possible, but some of the XML input samples you posted have a format like 8th October 2010 and sorting on that is not possible, you would first need to transform the format into something sortable with XSLT 1.0 (i.e. 'yyyy-mm-dd' or yyyymmdd).