How to get the following node children based on the node condition

JohnKiller · April 20th, 2012, 11:09 AM

I am using SaxonHE.

I need to check children nodes of Node N9, based on the children's values, then I need to get the child (children) of the node which is N9's sibling and just following N9.

My input XML:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<ISA>
  <ISA01>00</ISA01>
  <ISA02> </ISA02>
  <ISA03>00</ISA03>
  <GS>
    <GS01>PR</GS01>
    <GS02>FTRPO</GS02>
    <ST>
      <ST01>855</ST01>
      <ST02>0001</ST02>
      <BAK>
        <BAK01>11</BAK01>
        <BAK02>AT</BAK02>
        <BAK03>117624</BAK03>
        <BAK04>20020321</BAK04>
      </BAK>
      <DTM>
        <DTM01>097</DTM01>
        <DTM02>20020321</DTM02>
        <DTM03>162329</DTM03>
      </DTM>
      <SI>
        <SI01>TI</SI01>
        <SI02>IQ</SI02>
        <SI03>A</SI03>
      </SI>
      <N1>
        <N101>BY</N101>
        <N103>25</N103>
        <N104>180A</N104>
      </N1>
      <PO1>
        <PO101>1</PO101>
        <PO102>1</PO102>
        <PO103>EA</PO103>
        <PO106>A6</PO106>
        <PO107>ERR</PO107>
      </PO1>
      <N9>
      	<N901>1Q</N901>
      	<N902>FTRAVQ097</N902>
      	<N903>PRESPC</N903>
      </N9>
      <MTX>
      	<MTX02>WTN MAY ONLY BE 10 NUMERICS</MTX02>
      </MTX>
      <MTX>
	<MTX02>Following another MTX02</MTX02>
      </MTX>
      <SI>
      	<SI01>TI</SI01>
      	<SI02>LO</SI02>
      	<SI03>FTWYINIZH02</SI03>
      </SI>
      <SI>
      	<SI01>TI</SI01>
      	<SI02>AF</SI02>
      	<SI03>N</SI03>
      </SI>
      <SI>
      	<SI01>TI</SI01>
      	<SI02>CF</SI02>
      	<SI03>0</SI03>
      </SI>
      <MTX>
	<MTX02>Following the third MTX02</MTX02>
      </MTX>
      <CTT>
      	<CTT01>1</CTT01>
      </CTT>
    </ST>
  </GS>
</ISA>

My XSLT codes:

Code:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"
    exclude-result-prefixes="xs">
  <xsl:template match="ISA">
    <AV>
      <RES>
        <xsl:if test="GS/ST/BAK[BAK01 = '11' and BAK02 = 'AT']/BAK03">
          <xsl:attribute name="Number">
            <xsl:value-of select="GS/ST/BAK[BAK01 = '11' and BAK02 = 'AT']/BAK03"/>
          </xsl:attribute>
        </xsl:if>
        <xsl:if test="GS/ST/DTM[DTM01 = '097']">
          <xsl:attribute name="Time">
            <xsl:value-of select="GS/ST/DTM[DTM01='097']/DTM02"/>
            <xsl:value-of select="GS/ST/DTM[DTM01='097']/DTM03"/>
          </xsl:attribute>
        </xsl:if>
        <xsl:choose>
          <xsl:when test="GS/ST/N9[N901='1Q' and N903='PRESPC']/N902">
            <xsl:attribute name="Code">
              <xsl:value-of select="GS/ST/N9[N901='1Q' and N903='PRESPC']/N902"/>
            </xsl:attribute>
            <xsl:attribute name="Description">
              <xsl:value-of select="following-sibling::GS/ST/N9[N901='1Q' and N903='PRESPC'][1]/MTX02"/>
            </xsl:attribute>
          </xsl:when>
          <xsl:otherwise>
            <xsl:attribute name="Code">000</xsl:attribute>
            <xsl:attribute name="Description">Completed</xsl:attribute>
          </xsl:otherwise>
        </xsl:choose>
      </RES>
      <xsl:choose>
        <xsl:when test="GS/ST/PO1[PO101='1' and PO102='1' and PO103='EA' and PO106='A6' and PO107='GOOD']">
          <AD>Not for this case.</AD>
        </xsl:when>
        <xsl:otherwise>
          <AD>
            <xsl:element name="ERROR">
              <xsl:if test="GS/ST/PO1[PO101='1' and PO102='1' and PO103='EA' and PO106='A6' and PO107='ERR']">
                <xsl:attribute name="Code">
                  <xsl:value-of select="GS/ST/N9[N901='1Q' and N903='PRESPC']/N902"/>
                </xsl:attribute>
                <xsl:attribute name="Description">
                  <xsl:value-of select="following-sibling::GS/ST/N9[N901='1Q' and N903='PRESPC'][1]/MTX02"/>
                </xsl:attribute>
              </xsl:if>
            </xsl:element>
          </AD>
        </xsl:otherwise>
      </xsl:choose>
    </AV>
  </xsl:template>
</xsl:stylesheet>

My output XML should be:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<AV>
  <RES Number="117624" Time="20020321162329" Code="FTRAVQ097" Description="Tele MAY ONLY BE 10 NUMERICS"/>
  <AD>
    <ERROR Code="FTRAVQ097" Description="Tele MAY ONLY BE 10 NUMERICS"/>
  </AD>
</AV>

Right now, for my XSLT code, the output node's attribute Description is empty string (its value should be the first MTX/MTX02 following N9), and its value should be based on based on children's values of N9. I used the following-sibling, but it does not work.
Thank you in advance!

mhkay · April 20th, 2012, 11:20 AM

You are using following-sibling::GS at a point where the context node is an ISA element, but the ISA element does not have a following-sibling named GS. I'm not sure whose following-sibling you are looking for.

JohnKiller · April 20th, 2012, 11:24 AM

Thank you so much for replying. I am looking for ISA/GS/ST/N9's sibling's child, but I need to check N9's children to make sure this N9 is the one I am looking for. So check N9's children, then get the N9's sibling's children.

Martin Honnen · April 20th, 2012, 11:51 AM

I think instead of

Code:

following-sibling::GS/ST/N9[N901='1Q' and N903='PRESPC'][1]/MTX02

you want

Code:

GS/ST/N9[N901='1Q' and N903='PRESPC'][1]/following-sibling::MTX/MTX02

or perhaps only the first sibling e.g.

Code:

GS/ST/N9[N901='1Q' and N903='PRESPC'][1]/following-sibling::MTX[1]/MTX02

JohnKiller · April 20th, 2012, 12:08 PM

Thank you so much, Martin. I am confusing about the follow-sibling::node.
For my case,

Code:

GS/ST/N9[N901='1Q' and N903='PRESPC'][1]/following-sibling::MTX[1]/MTX02

I was thinking is should be ::N9, I would like to know why?

Martin Honnen · April 20th, 2012, 01:05 PM

Well with XPath if you have a path expression selecting a node or a node-set or (XPath 2.0) a sequence of nodes then if you want to select nodes relative to those nodes or if you want to navigate to other nodes relative to those nodes then you add a step at the end of the expression.

And then you should make yourself familiar with the XPath axes with a book or tutorial like http://www.xmlplease.com/axis.

JohnKiller · April 20th, 2012, 01:10 PM

Thank you so much for the information, Martin. Recently we changed to use XSLT2.0 processor, and I do not get used of it. And the tutorial which you give is pretty good.