|
|
 next
|
  Subject: Not grouping all nodes
Author: Daniel Frechette
Date: 22 May 2006 01:00 PM
Originally Posted: 22 May 2006 12:54 PM
|
Hi,
I want to group activities by distance (e.g. unspecified, on site, within 1 km, within 5 km, etc.). For each activity, a distance may or may not be specified. Activities with no distances, are grouped under 'unspecified'.
The problem is that when no distance is specified and non activity nodes are present (see 'facilities' node in XML file), activities with no distances are simply ignored. Why?? Is there a solution to this problem?
Thank you for your help.
Expected output:
<distance value="Unspecified">
<activity>Kayak</activity>
</distance>
<distance value="On site">
<activity>Golf</activity>
<activity>Tennis</activity>
</distance>
<distance value="Within 1 km">
<activity>Football</activity>
</distance>
<distance value="Within 5 km">
<activity>Ski</activity>
</distance>
Here is my XSL script:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:key name="grp" match="value" use="attribute[@name='value']"/>
<xsl:template match="/">
<xsl:for-each select="//property/attribute[@name='activities']">
<xsl:for-each select="value[count(.|key('grp',attribute[@name='value'])[1])=1]">
<xsl:sort select="attribute[@name='value']/value/@order" />
<distance>
<xsl:attribute name="value">
<xsl:value-of select="attribute[@name='value']/value" />
<xsl:if test="not(attribute[@name='value']/value)">
<xsl:text>Unspecified</xsl:text>
</xsl:if>
</xsl:attribute>
<xsl:for-each select="key('grp',attribute[@name='value'])">
<xsl:sort select="attribute[@name='literal']/value"/>
<activity>
<xsl:value-of select="attribute[@name='literal']/value" />
</activity>
</xsl:for-each>
</distance>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Here is my XML data:
<?xml version="1.0" encoding="UTF-8"?>
<data>
<model>
<property>
<attribute name="activities">
<value>
<attribute name="literal">
<value>Kayak</value>
</attribute>
<attribute name="value"></attribute>
</value>
<value>
<attribute name="literal">
<value>Ski</value>
</attribute>
<attribute name="value">
<value order="3">Within 5 km</value>
</attribute>
</value>
<value>
<attribute name="literal">
<value>Tennis</value>
</attribute>
<attribute name="value">
<value order="1">On site</value>
</attribute>
</value>
<value>
<attribute name="literal">
<value>Football</value>
</attribute>
<attribute name="value">
<value order="2">Within 1 km</value>
</attribute>
</value>
<value>
<attribute name="literal">
<value>Golf</value>
</attribute>
<attribute name="value">
<value order="1">On site</value>
</attribute>
</value>
</attribute>
<attribute name="facilities">
<value>
<attribute name="literal">
<value>Bar / Lounge</value>
</attribute>
<attribute name="value"></attribute>
</value>
</attribute>
</property>
</model>
</data>
|
|
|
|
activities.xsl
top