RE: [xsl] Use of xsl:key to perform node traversal according to an association between nodes

Subject: RE: [xsl] Use of xsl:key to perform node traversal according to an association between nodes
From: "Dunk, Michael (Mike)" <mikedunk@xxxxxxxxxxxxx>
Date: Wed, 26 Sep 2007 11:09:16 -0500
It works fine now.

Amending the XSLT as you suggested to become:

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

<xsl:key name="player-id" match="Teams_and_Players/Players/Player"
use="@id"/>

<xsl:template match="/">
  <xsl:message> root found </xsl:message>
  <xsl:apply-templates select="Teams_and_Players"/>
</xsl:template>

<xsl:template match="Teams_and_Players">
 <Teams>
  <xsl:message> Teams_and_Players found </xsl:message>
  <xsl:apply-templates select="Teams"/>
 </Teams>
</xsl:template>

<xsl:template match="Teams">
  <xsl:message> Teams found </xsl:message>
  <xsl:apply-templates select="Team"/>
</xsl:template>

<xsl:template match="Team">
  <Team>
  <xsl:message> Team found </xsl:message>
  <xsl:value-of select="@name"/>
  <xsl:apply-templates select="TeamPlayer"/>
  </Team>
</xsl:template>

<xsl:template match="TeamPlayer">
  <xsl:message> TeamPlayer found </xsl:message>
  <Player>
  <xsl:value-of select="key('player-id', .)/@name"/>
  </Player>
</xsl:template>
</xsl:stylesheet>

Once again, many thanks to Wendell Piez, Scott Trenda and Brad
Bjorndahl.

Best regards,

Mike


-----Original Message-----
From: Wendell Piez [mailto:wapiez@xxxxxxxxxxxxxxxx]
Sent: 26 September 2007 16:34
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [xsl] Use of xsl:key to perform node traversal according to
an association between nodes

Mike,

At 10:29 AM 9/26/2007, Brad wrote:
>I think it's correct except for:
><xsl:value-of select="key('player-id', @id)"/>
>
>which should be changed to:
><xsl:value-of select="key('player-id', .)"/>
>
>because it's the content for TeamPlayer that you need to match to
>the key entries. TeamPlayer does not have an id attribute.

Also, once you've correctly selected the Player node, you presumably
want to output its @name, not its value (since it's empty).

So that would be

<xsl:value-of select="key('player-id', .)/@name"/>

Or there might be times (with problems of real-world complexity) when
you even want to do:

<xsl:apply-templates select="key('player-id', .)" mode="name"/>

<xsl:template match="Player" mode="name">
   <xsl:value-of select="@name"/>
</xsl:template>

Cheers,
Wendell

>-----Original Message-----
>From: Dunk, Michael (Mike) [mailto:mikedunk@xxxxxxxxxxxxx]
>Sent: September 26, 2007 10:15 AM
>To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
>Subject: [xsl] Use of xsl:key to perform node traversal according to
>an association between nodes

...

>  Here is an simplified example of the type of xml input I need to
read:
>
><?xml version="1.0" encoding="UTF-8"?>
><Teams_and_Players>
>   <Teams>
>     <Team name="Man Utd">
>
><TeamPlayer>{0EA17FA0-D21B-4F1E-8B11-A250A6CF266C}+00000000</TeamPlayer
>
>
><TeamPlayer>{1F3E974C-F180-45EB-AB59-4D1ACF4BB855}+00000000</TeamPlayer
>
>
><TeamPlayer>{3F9BEEE0-35DB-4835-A89E-F2B240EC2CB0}+00000000</TeamPlayer
>
>     </Team>
>   </Teams>
>   <Players>
>     <Player id="{0EA17FA0-D21B-4F1E-8B11-A250A6CF266C}+00000000"
>name="Gary Neville"></Player>
>     <Player id="{1F3E974C-F180-45EB-AB59-4D1ACF4BB855}+00000000"
>name="Louis Saha"></Player>
>     <Player id="{3F9BEEE0-35DB-4835-A89E-F2B240EC2CB0}+00000000"
>name="Ryan Giggs"></Player>
>   </Players>
></Teams_and_Players>
>
>
>The xslt written to list the teams and players is :
>
><?xml version='1.0'?>
><xsl:stylesheet version="2.0"
>xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
><xsl:output method="xml"/>
>
><xsl:key name="player-id" match="Teams_and_Players/Players/Player"
>use="@id"/>
>
><xsl:template match="/">
>   <xsl:apply-templates select="Teams_and_Players"/> </xsl:template>
>
><xsl:template match="Teams_and_Players">  <Teams>
>   <xsl:apply-templates select="Teams"/>
>  </Teams>
></xsl:template>
>
><xsl:template match="Teams">
>   <xsl:apply-templates select="Team"/>
></xsl:template>
>
><xsl:template match="Team">
>   <Team>
>   <xsl:value-of select="@name"/>
>   <xsl:apply-templates select="TeamPlayer"/>
>   </Team>
></xsl:template>
>
><xsl:template match="TeamPlayer">
>   <Player>
>   <xsl:value-of select="key('player-id', @id)"/>
>   </Player>
></xsl:template>
></xsl:stylesheet>
>
>Currently the following is output:
>
><?xml version="1.0" encoding="UTF-8"?>
><Teams>
>   <Team>Man Utd
>     <Player/>
>     <Player/>
>     <Player/>
>   </Team>
></Teams>
>
>Has anyone got any clues about what is wrong with?
>
><xsl:key name="player-id" match="Teams_and_Players/Players/Player"
>use="@id"/>
>
>or
>
><xsl:value-of select="key('player-id', @id)"/>
>
>Best regards,
>
>Mike
>
>
>This email and any files transmitted with it are confidential,
>proprietary and intended solely for the individual or entity to whom
>they are addressed..
>If you have received this email in error please delete it immediately.


======================================================================
Wendell Piez                            mailto:wapiez@xxxxxxxxxxxxxxxx
Mulberry Technologies, Inc.                http://www.mulberrytech.com
17 West Jefferson Street                    Direct Phone: 301/315-9635
Suite 207                                          Phone: 301/315-9631
Rockville, MD  20850                                 Fax: 301/315-8285
----------------------------------------------------------------------
   Mulberry Technologies: A Consultancy Specializing in SGML and XML
======================================================================

This email and any files transmitted with it are confidential, proprietary
and intended solely for the individual or entity to whom they are addressed.
If you have received this email in error please delete it immediately.

Current Thread