[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Group and sort nodes by attribut in child node
Wow. Thanks for the quick reply. First of all, sorry for not telling that i have to use XSLT 1.0. I knew i forgot something. The result your style sheet produces meets my requirement perfectly but i need it, as I said for XSLT 1.0. Nodes where the group value is empty should not be in the same group so what you did is perfect. Is there any way to do this for xslt 1.0? Thank you. Jens >Martin Honnen wrote: >> Jens Burkhardt wrote: >> >>> The result should be like this: >>> A - 23.10.2010 >>> X_Group >>> C - 23.10.2010 >>> B - 24.12.2010 >>> D - 25.10.2010 >>> Y_Group >>> D - 25.12.2010 >>> E - 26.12.2010 >>> >>> I want to group by the value of the group field in the column node and >>> everything should be sorted by start_date. The name of the group (e.g. >>> X_Group) should start a group-block, followed by the record nodes >>> which belong to the group value. >>> Another problem is that i donB4t know the group value in advance, >>> because they can be set to whatever the user want. >> >> Do you use XSLT 2.0 or 1.0? >> And what about the record with keyword value "A" and the one with >> keyword value "D" where the group value is an empty string? Shouldn't >> they be in the same group? > >Here is an XSLT 2.0 stylesheet that sorts first and the groups adjacent >records in the sorted sequence: > ><xsl:stylesheet > xmlns:xsl="http://www.w3.org/1999/XSL/Transform" > xmlns:xs="http://www.w3.org/2001/XMLSchema" > exclude-result-prefixes="xs" > version="2.0"> > > <xsl:output method="text"/> > > <xsl:template match="records"> > <xsl:variable name="sorted" as="element(record)*"> > <xsl:perform-sort select="record"> > <xsl:sort select="xs:date(concat(substring(column[@field = >'Start_Date']/@value, 7), '-', > substring(column[@field = >'Start_Date']/@value, 4, 2), '-', > substring(column[@field = >'Start_Date']/@value, 1, 2)))"/> > </xsl:perform-sort> > </xsl:variable> > <xsl:for-each-group select="$sorted" group-adjacent="column[@field >= 'Group']/@value"> > <xsl:choose> > <xsl:when test="current-grouping-key()"> > <xsl:value-of select="current-grouping-key()"/> > <xsl:text> </xsl:text> > <xsl:value-of select="current-group()/concat(' ', >column[@field = 'keyword']/@value, ' - ', column[@field = >'Start_Date']/@value)" > separator=" "/> > <xsl:text> </xsl:text> > </xsl:when> > <xsl:otherwise> > <xsl:value-of select="current-group()/concat(column[@field = >'keyword']/@value, ' - ', column[@field = 'Start_Date']/@value)"/> > <xsl:text> </xsl:text> > </xsl:otherwise> > </xsl:choose> > </xsl:for-each-group> > </xsl:template> > ></xsl:stylesheet> > >With that stylesheet Saxon 9.3 HE, when applying it to the input > ><records> ><record> > <column field="keyword" value="A"></column> > <column field="Start_Date" value="23.12.2010"></column> > <column field="Group" value=""></column> ></record> ><record> > <column field="keyword" value="B"></column> > <column field="Start_Date" value="24.12.2010"></column> > <column field="Group" value="X_Group"></column> ></record> ><record> > <column field="keyword" value="D"></column> > <column field="Start_Date" value="25.12.2010"></column> > <column field="Group" value=""></column> ></record> ><record> > <column field="keyword" value="C"></column> > <column field="Start_Date" value="23.12.2010"></column> > <column field="Group" value="X_Group"></column> ></record> ><record> > <column field="keyword" value="D"></column> > <column field="Start_Date" value="25.12.2010"></column> > <column field="Group" value="Y_Group"></column> ></record> ><record> > <column field="keyword" value="E"></column> > <column field="Start_Date" value="26.12.2010"></column> > <column field="Group" value="Y_Group"></column> ></record> ></records> > >outputs > >A - 23.12.2010 >X_Group > C - 23.12.2010 > B - 24.12.2010 >D - 25.12.2010 >Y_Group > D - 25.12.2010 > E - 26.12.2010 > > >Does that solution meet your requirement? ___________________________________________________________ SMS schreiben mit WEB.DE FreeMail - einfach, schnell und kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|