XSL - Value of select with several sub-nodes matching

Question

This is my first time working with XSLT files. I have to change a report using a XSL file and I have the following problem:

I have 3 variables which have to match to identify my right XML tag
One of these variable is defined in a sub-sub-tag
My result is located in the first sub-tag

To choose the right attribute, I use the following XSL code:

<xsl:for-each select="MSMResults/MSMVarContribs/Contrib">
  <xsl:variable name="PrtAsmType"><xsl:value-of select="@PrtAsmType"/></xsl:variable> 
  <xsl:variable name="CadName"><xsl:value-of select="@PrtAsmCadName"/></xsl:variable> 
  <xsl:variable name="ContribType"><xsl:value-of select="@Type"/></xsl:variable> 
  <xsl:variable name="ID"><xsl:value-of select="@ID"/></xsl:variable>
  <xsl:value-of select="/CETOLReport/PrtAsm[@Type=$PrtAsmType and @CadName=$CadName and /Feature/SizeDimension/Variable/@ID=$ID]//SizeDimension/@Note"/>

This is the XML file (shortened):

<CETOLReport>   
<PrtAsm Type="PART" CadName="PRT0001" Name="PRT0001">
  <VariationRule>
  <Alerts Count="0"/>
  <Feature>
  ...
  </Feature>
  ...
  <Feature Note="">
     <Alerts Count="0"/>
     <SizeDimension Note="PRT001&#xa;dim.# 01">
        <Tolerance Lower="0.1" Upper="0.2"/>
        <VariationRule ControlSkew="TRUE"/>
        ...
        <Variable Note="" Nominal="9" ID="12">
           <Distribution Mean="9.149999999999999"/>
           <Alerts Count="0"/>
        </Variable>
     </SizeDimension>
     <Dimension>
     ...
     </Dimension>
     <Dimension>
     ...
     </Dimension>
  </Feature>
  <Feature>
  ...
  </Feature>
</PrtAsm>
</CETOLReport>

Summed up:

I have to match

the attribute Type in <PrtAsm>
the attribute CadName in <PrtAsm>
the attribute ID in <PrtAsm/Feature/SizeDimension/Variable>

and as an output I want

the attribute Note in <PrtAsm/Feature/SizeDimension>

What do I have to change in <xsl:value-of select="/CETOLReport/PrtAsm[@Type=$PrtAsmType and @CadName=$CadName and /Feature/SizeDimension/Variable/@ID=$ID]//SizeDimension/@Note"/> to get the right answer?

Is it just a copy error in your question? you didn't close the tag while defining the variables. See for example: — Loic Mouchard, Jun 02 '16 at 11:45
Hi Loic, yes that is just a copy error. I will change it in my question, thank you! — Lars Fischheiter, Jun 02 '16 at 12:05
Please do not add "thank you" as an answer. Instead, you should accept the answer that solved your problem. When you have enough reputation, you can also [upvote helpful answers](http://stackoverflow.com/help/privileges/vote-up) or [award a bounty to helpful answers](http://stackoverflow.com/help/bounty). — elixenide, Jun 06 '16 at 15:49

Loic Mouchard · Answer 1 · 2016-06-02T14:30:55.493

0

I would try:

<xsl:value-of select="/CETOLReport/PrtAsm[@Type=$PrtAsmType and @CadName=$CadName and Feature/SizeDimension/Variable/@ID=$ID]/Feature/SizeDimension[1]/@Note"/>

edited Jun 02 '16 at 14:30

answered Jun 02 '16 at 11:49

Loic Mouchard

1,121
7
22

Hi Loic, thanks for your suggestion, but correcting the "//" to "/" didn't bring up the desired output. – Lars Fischheiter Jun 02 '16 at 12:07
did you also remove the `/` before `Feature` ? – Loic Mouchard Jun 02 '16 at 13:13

score 0 · Answer 2 · answered Jun 02 '16 at 13:05

0

Try this....

<xsl:value-of select="/CETOLReport
                      /PrtAsm[@Type=$PrtAsmType and @CadName=$CadName]
                      /Feature/SizeDimension[Variable/@ID=$ID]/@Note"/>

answered Jun 02 '16 at 13:05

Tim C

70,053
14
74
93

XSL - Value of select with several sub-nodes matching

2 Answers2