nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multiple predicates in BIRT XPath expressions

Alexutz

Hello, 
 
I am designing a report using XML as a data source. The XML is a bit special in that it has this specific structure: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<Object type="Contact" id="75251" version="3">
<Attribute name="first-name">ff</Attribute>
<Attribute name="middle-name">ff</Attribute>
<Attribute name="last-name">ff</Attribute>
<Reference name="Member" type="object">
<Object type="Member" id="75001" version="2">
<Attribute name="state">DISABLED</Attribute>
<Attribute name="locked">false</Attribute>
<Attribute name="login">tester123</Attribute>
</Object>
</Reference>

</Object>
</pre>
 
Attributes of an object are elements named Attribute and have a name attribute which I have to use in teh XPath in order to get the specific value I want. Also I have to differentiate between reference elements to get the one I want. For example, to get the Member state I need to isolate the Member from all references and then isolate the state attribute by using multiple predicates as follows: 
 
/Reference/Object/Attribute[../@type=';Member' and @name=';state'] 
 
While this works in all xpath vizualizers BIRT is giving me a hard time and does not display anything. I've also tried, without success, variations such as: 
 
/Reference/Object[@type=';Member']/Attribute[@name=';state'] 
 
/Reference[@name=';Member']/Object/Attribute[@name=';state'] 
 
Do you have any ideas on how can I achieve this with the BIRT's implementation of XPath? 
 
Thanks

Find more posts tagged with

Comments

mwilliams

If all the XML you were to have was the above, this gets what you're wanting:

/Reference/Object/Attribute[@name=';state']

But, this probably wouldn't work if there were multiple objects and some weren't "member" and you wanted to only grab those. Can you post just a little more data for me to try different things with?

Alexutz

Hi Michael, 
 
I have indeed multiple objects and they are not "member". Below is a more detailed example: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<Object type="Contact" id="75251" version="3">
<Attribute name="first-name">ff</Attribute>
<Attribute name="middle-name">ff</Attribute>
<Attribute name="last-name">ff</Attribute>
<Reference name="PhoneNumbers" type="collection"/>
<Reference name="Emails" type="collection"/>
<Reference name="PostalAddresses" type="collection"/>
<Attribute name="civility">Mr.</Attribute>
<Reference name="Organization" type="object">
<Object type="Organization" id="75002" version="2">
<Attribute name="name">Org1</Attribute>
<Attribute name="state">ENABLED</Attribute>
</Object>
<Reference>
<Reference name="Member" type="object">
<Object type="Member" id="75001" version="2">
<Attribute name="state">DISABLED</Attribute>
<Attribute name="locked">false</Attribute>
<Attribute name="login">tester123</Attribute>
</Object>
</Reference>

</Object>
</pre>
 
Thanks.

mwilliams

I've tried everything I can think of to get the value you want, but it doesn't seem to be possible with BIRT's XPath. You might log a bug for this at http://www.birt-exchange.org/org/resources/bug-reporting/ and see if they have a suggestion for a workaround.