George Pirkulov
George Pirkulov

Reputation: 83

how to group elements in XSLT

Faced with difficulties in solving the problem by means of grouping elements XSLT. Do I have to use the xsl: key? if so, how to do it or more xsl: for-each? Here is my problem. My XML file:

<page>
<name>test</name>
<property id="416" name="country" type="relation">
    <title>Country</title>
        <value>
            <item id="1014" name="Canada"/>
        </value>
    </property>
</page>

and items such pieces 20, each has a name (non-recurring, and their own country, can be repeated) How to derive such elements grouped by country? for example:

<h1>Canada</h1>
<h2>test<h2>
<h2>test2<h2>

<h1>England</h1>
<h2>test3</h2>
<h2>test3</h2>

UPDATE:

   <page id="423" parentId="421" link="/producers/oao_nii_elpa/" is-active="1" object-id="1020" type-id="67" type-guid="catalog-category" update-time="1350295423" alt-name="oao_nii_elpa">
<basetype id="44" module="catalog" method="category">Catalog category</basetype>
<name>Nii elpa</name>
<properties>
<group id="130" name="common">
<title>Params</title>
<property id="116" name="h1" type="string">
<title>H1 field</title>
<value>Nii elpa</value>
</property>
</group>
<group id="131" name="menu_view">
<title>Menu View</title>
<property id="123" name="header_pic" type="img_file">
<title>Header_Pic</title>
<value path="./images/cms/headers/elpa.jpg" folder="/images/cms/headers" name="elpa" ext="jpg" width="139" height="63">/images/cms/headers/elpa.jpg</value>
</property>
</group>
<group id="133" name="additional">
<title>Additional</title>
<property id="416" name="country" type="relation">
<title>Country</title>
<value>
<item id="3" guid="a1e3ae17e80ba2b4a3ddb1b855430346f74b8d48" name="England" type-id="4" type-guid="d69b923df6140a16aefc89546a384e0493641fbe" ownerId="42" xlink:href="uobject://3"/>
</value>
</property>
</group>
</properties>
</page>

Upvotes: 4

Views: 802

Answers (1)

Joep
Joep

Reputation: 4133

For XSLT 1.0 the way to group is done by the muenchian method, e.g.:
(source: http://www.jenitennison.com/xslt/grouping/muenchian.html)

We have an XML:

<records>
    <contact id="0001">
        <title>Mr</title>
        <forename>John</forename>
        <surname>Smith</surname>
    </contact>
    <contact id="0002">
        <title>Dr</title>
        <forename>Amy</forename>
        <surname>Jones</surname>
    </contact>
    ...
</records>

And we wan't to group by surname, and produce the following output:

Jones,<br />
    Amy (Dr)<br />
    Brian (Mr)<br />
Smith,<br />
    Fiona (Ms)<br />
    John (Mr)<br />

This is accomplished by the following XSLT 1.0 template and key:

<xsl:key name="contacts-by-surname" match="contact" use="surname" />
<xsl:template match="records">
    <xsl:for-each select="contact[count(. | key('contacts-by-surname', surname)[1]) = 1]">
        <xsl:sort select="surname" />
        <xsl:value-of select="surname" />,<br />
        <xsl:for-each select="key('contacts-by-surname', surname)">
            <xsl:sort select="forename" />
            <xsl:value-of select="forename" /> (<xsl:value-of select="title" />)<br />
        </xsl:for-each>
    </xsl:for-each>
</xsl:template>

The template for your problem would look like this (untested):

<xsl:key name="page-by-country" match="page" use="property[@name='country']/value/item/@name" />
<xsl:template match="pages">
    <xsl:for-each select="page[count(. | key('page-by-country', property[@name='country']/value/item/@name)[1]) = 1]">
        <xsl:sort select="property[@name='country']/value/item/@name" />
        <h1><xsl:value-of select="property[@name='country']/value/item/@name" /></h1>
        <xsl:for-each select="key('page-by-country', property[@name='country']/value/item/@name)">
            <xsl:sort select="name" />
            <h2><xsl:value-of select="name"/></h2>
        </xsl:for-each>
    </xsl:for-each>
</xsl:template>

See this working example for your problem: xsltransform.net

Upvotes: 2

Related Questions