Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Xpath referencing different XML field
Migrateduser
<div>Hi, </div>
<div>I have This XML with two groups with exactly the same structure.</div>
<div>.</div>
<div>.</div>
<div>.</div>
<div><core:ReferenceCoded></div>
<div> <core:ReferenceTypeCoded>Other</core:ReferenceTypeCoded></div>
<div> <core:ReferenceTypeCodedOther>BuyerProductNumber</core:ReferenceTypeCodedOther></div>
<div> <core:PrimaryReference></div>
<div> <core:RefNum>PR010001</core:RefNum></div>
<div> </core:PrimaryReference></div>
<div></core:ReferenceCoded></div>
<div> </div>
<div> </div>
<div><core:ReferenceCoded></div>
<div> <core:ReferenceTypeCoded>Other</core:ReferenceTypeCoded></div>
<div> <core:ReferenceTypeCodedOther>EanProductNumber</core:ReferenceTypeCodedOther></div>
<div> <core:PrimaryReference></div>
<div> <core:RefNum>8430469105824</core:RefNum></div>
<div></core:PrimaryReference></div>
<div></core:ReferenceCoded></div>
<div>.</div>
<div>.</div>
<div>.</div>
<div> </div>
<div>I need the value of the value <span style="color:#FF0000;"><core:RefNum></core:RefNum></span> with <span style="color:#FF0000;"><core:ReferenceTypeCodedOther>EanProductNumber</core:ReferenceTypeCodedOther></span> (in this case the value will be 8430469105824)</div>
<div> </div>
<div>If I write this Xpath I have the correct value (8430469105824)</div>
<div> </div>
<div>-<span> </span>core:ReferenceCoded<span style="color:#FF0000;">[2]</span>/core:PrimaryReference/core:RefNum</div>
<div> </div>
<div>But I don't know if the value will be in group 1 or 2 so I can't use [1] or [2]. I need to check the field core:ReferenceTypeCodedOther</div>
<div> </div>
<div>I have tried a lot of combinations but always the same result. No value is shown.</div>
<div> </div>
<div>core:ReferenceCoded[core: ReferenceTypeCodedOther =" EanProductNumber"]/core:PrimaryReference/core:RefNum</div>
<div>core:ReferenceCoded[core: ReferenceTypeCodedOther =' EanProductNumber']/core:PrimaryReference/core:RefNum</div>
<div>core:ReferenceCoded[core: ReferenceTypeCodedOther ==" EanProductNumber"]/core:PrimaryReference/core:RefNum</div>
<div>core:ReferenceCoded[core: ReferenceTypeCodedOther ==' EanProductNumber']/core:PrimaryReference/core:RefNum</div>
<div>core:ReferenceCoded[core: ReferenceTypeCodedOther [text()=" EanProductNumber"]]/core:PrimaryReference/core:RefNum</div>
<div>core:ReferenceCoded[core: ReferenceTypeCodedOther [text()=' EanProductNumber']]/core:PrimaryReference/core:RefNum</div>
<div>core:ReferenceCoded[core: ReferenceTypeCodedOther [text()==" EanProductNumber"]]/core:PrimaryReference/core:RefNum</div>
<div>core:ReferenceCoded[core: ReferenceTypeCodedOther [text()==" EanProductNumber"]]/core:PrimaryReference/core:RefNum</div>
<div>.</div>
<div>.</div>
<div>.</div>
<div>And all similar combinations</div>
<div> </div>
<div>Sorry, I'm new in BIRT and I'm Lost.</div>
<div> </div>
<div>Thank you for your help.</div>
Find more posts tagged with
Comments
There are no comments yet