Need help with XPATH Expression

benomathew · May 9th, 2006, 03:02 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.

vakorde · May 12th, 2006, 04:41 AM

This XPath will solve your problem
/CCR/Actors/Actor[ActorID='AA0009']/Person/Name/DisplayName

---------------------------
Vikrant Korde
3i Infotech, Vashi,
Mumbai, Maharashtra, India.