Sort XML with XSL

20 October 2012, 19:52

Keywords: xsl, sort, merge, feed

Starting with version 1.2, etc_query supports XSL stylesheets. An immediate benefice is the possibility to sort an XML document. In the example below we mix and rearrange by date <txp:article_custom /> and <txp:recent_comments /> lists:

<txp:etc_query
	data='<dl>
	<txp:article_custom>
		<dt><txp:posted format="%Y-%m-%d" /></dt>
		<dd>Published <txp:permlink><txp:title /></txp:permlink></dd>
	</txp:article_custom>
	<txp:recent_comments break="">
		<dt><txp:comment_time format="%Y-%m-%d" /></dt>
		<dd>Comment on <txp:comment_permlink><txp:title /></txp:comment_permlink> by <txp:comment_name /></dd>
	</txp:recent_comments>
	</dl>'
>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:txp="https://www.textpattern.com">
<xsl:output method="html" encoding="utf-8" omit-xml-declaration="yes" />
<xsl:template match="dl">
	<h4>History</h4>
	<dl>
	<xsl:for-each select="dt">
		<xsl:sort select="." order="descending" />
		<xsl:if test="position() &lt; 11">
		<txp:if_different><xsl:copy-of select="." /></txp:if_different>
		<xsl:copy-of select="following-sibling::dd[1]" />
		</xsl:if>
	</xsl:for-each>
	</dl>
</xsl:template>
</xsl:stylesheet>
</txp:etc_query>

History (page 17)

2013-12-09
Comment on Copy image protect by Oleg
2013-12-06
Published Reviews test
Comment on Reviews test by etc_test
Comment on Reviews test by springworks
Comment on Reviews test by springworks
Comment on Reviews test by Springworks
Comment on Reviews test by Uli
Comment on Reviews test by etc_test
Comment on Reviews test by etc_test
Comment on Reviews test by etc_test

But what about pagination? Here it is:

File(s)