Xpath functions in the Birt

vidoo

<div>Hello,</div>
<div> </div>
<div>I have a problem to use some Xpath functions in the Birt.</div>
<div> </div>
<div>my example is </div>
<div> </div>
<div>/contact/relationship/coding/code[@value=&quot;1"]/../../../extension/valueResource/reference/@value&lt;/div>
<div> </div>
<div>but it does not work</div>
<div> </div>
<div>part of xml is </div>
<div> </div>
<div><contact></div>
<div>               <extension></div>
<div>                  <valueResource></div>
<div>                     <reference value="person/1000004218/_history/1000004738"/></div>
<div>                  </valueResource></div>
<div>               </extension></div>
<div>               <relationship></div>
<div>                  <coding></div>
<div>                     <code value="1"/></div>
<div>                  </coding></div>
<div></relationship></div>
<div></contact></div>
<div> </div>
<div>Maybe there is solution for this case?</div>

Clement Wong

<p>It appears that that XPath expression is valid based on a few online XPath testers.</p>
<p> </p>
<p>The following worked for me in commercial BIRT Designer Professional iHub3 (but should work in OS BIRT) to get you the result you're looking for.  Define a new DataSet and start at "code" where value is 1.  Then get the value of "reference".</p>
<p> </p>
<p><u><strong>Step 1 - Row mapping</strong></u></p>
<p>/contact/relationship/coding/code/[@value=&quot;1"]</p>
<p> </p>
<p><u><strong>Step 2 - Column mapping</strong></u></p>
<p> (point and click to get to @value and choose XML elements at fixed absolute path)</p>
<p>Column name: referenceValue</p>
<p>XPath exp: ../../../extension/valueResource/reference/@value&lt;/p>