Need help with XPATH Expression

benomathew · May 9th, 2006, 03:01 PM

I have an XML file as follows...
<CCR>
<Body>
   <Encounters>
    <Encounter>
      <Source>
       <Actor>
           <ActorID>AA0009</ActorID>
           </Actor>
      </Source>
    </Encounter>
  </Encounters>
</Body>
<Actors>
  <Actor>
     <ActorID>AA0009</ActorID>
     <Person>
     <Name>
         <DisplayName>AR</DisplayName>
         </Name>
     </Person>
  </Actor>
  <Actor>
     <ActorID>AA00010</ActorID>
     <Person>
     <Name>
         <DisplayName>ART</DisplayName>
         </Name>
     </Person>
  </Actor>
  <Actor>
     <ActorID>AA00011</ActorID>
     <Person>
     <Name>
         <DisplayName>ER</DisplayName>
         </Name>
     </Person>
  </Actor>
</Actors>
</CCR>

Using XPATH, how do I retrieve the 'displayname'(AR) by referencing it using the 'ActorID' (AA0009).

When I use the expression /CCR/Actors/Actor[ActorObjectID = /CCR/Body/Encounters/Encounter/Source/Actor/ActorID ]/Person/Name/DisplayName , I get all of the 3 'displayname' . I just want the display name that has AA0009 as the 'actorid'. How do i do it? I am using Altova StyleVision.

mhkay · May 9th, 2006, 03:38 PM

I can't see why you would get anything with the path expression given because Actor doesn't have a child called ActorObjectID.

Try

/CCR/Actors/Actor[ActorID = /CCR/Body/Encounters/Encounter/Source/Actor/ActorID]/Person/Name/DisplayName

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference