I'm sure this has been asked before but I can't find the answer.
I have the following xml which I am processing by sorting using
<xsl:for-each select="//property[@type='MoveSuccess']">
<xsl:sort select="./property[@name='sourceace']" data-type="text" order="ascending"/>
When I get to a change of sourceace and targetace I need to output a count of the number of MoveSuccess elements I have procesed.
I have tried all sorts of combinations of rule. my current attempt loks like this using the variable ace (which contains the correct value Naa030 first time).
<xsl:value-of select="count(ancestor::moveBatchResults/descendant:
roperty[$ace=concat(./property[@name='sourceSPV'],./property[@name='targetSPV'])])"/>
But I can't get the correct count.
Anyone got any ideas please
<?xml version="1.0" encoding="UTF-8"?>
<moveBatchResults>
<property type="MoveResultCVO">
<property name="moveResults" type="ArrayList">
<property type="MoveFailure">
<property type="MoveVO" name="moveVO">
<property name="movement" type="String">MOVE</property>
<property name="ace" type="String">aa030</property>
<property name="reasonCode" type="null"/>
</property>
<property name="errorMessage" type="String">Target ace must belong to Current ace</property>
</property>
<property type="MoveSuccess">
<property name="movement" type="String">MOVE</property>
<property name="Balance" type="Double">-361344.46</property>
<property name="cofElementInformationVOs" type="ArrayList">
<property type="ElementInformationVO">
<property name="Balance" type="Double">-28545.43</property>
<property name="clasNumber" type="String">10126584</property>
</property>
<property type="ElementInformationVO">
<property name="Balance" type="Double">-92196.87999999999</property>
<property name="clasNumber" type="String">10126584</property>
</property>
<property type="ElementInformationVO">
<property name="Balance" type="Double">-240602.15000000002</property>
<property name="clasNumber" type="String">10126584</property>
</property>
</property>
<property name="mfNo" type="String">aa550U-00517</property>
<property name="targetace" type="String">aa030</property>
<property name="sourceace" type="String">aa029</property>
</property>
<property type="MoveSuccess">
<property name="movement" type="String">MOVE</property>
<property name="Balance" type="Double">1.48929757415317E-11</property>
<property name="cofElementInformationVOs" type="ArrayList">
<property type="ElementInformationVO">
<property name="Balance" type="Double">-7.275957614183426E-12</property>
<property name="clasNumber" type="String">10115129</property>
</property>
<property type="ElementInformationVO">
<property name="Balance" type="Double">2.546585164964199E-11</property>
<property name="clasNumber" type="String">10115129</property>
</property>
<property type="ElementInformationVO">
<property name="Balance" type="Double">-5.684341886080801E-13</property>
<property name="clasNumber" type="String">10115129</property>
</property>
<property type="ElementInformationVO">
<property name="capitalBalance" type="Double">-2.7284841053187847E-12</property>
<property name="clasNumber" type="String">10115129</property>
</property>
</property>
<property name="mfNo" type="String">ooo50T-00133</property>
<property name="targetace" type="String">aa030</property>
<property name="sourceace" type="String">N</property>
</property>
<property type="MoveSuccess">
<property name="movement" type="String">MOVE</property>
<property name="Balance" type="Double">-2.0463630789890885E-12</property>
<property name="cofElementInformationVOs" type="ArrayList">
<property type="ElementInformationVO">
<property name="Balance" type="Double">-2.0463630789890885E-12</property>
<property name="clasNumber" type="String">10119258</property>
</property>
</property>
<property name="mfNo" type="String">lll50K-00023</property>
<property name="targetace" type="String">aa030</property>
<property name="sourceace" type="String">N</property>
</property>
</property>
</property>
</moveBatchResults>
I have the following xml which I am processing by sorting using
<xsl:for-each select="//property[@type='MoveSuccess']">
<xsl:sort select="./property[@name='sourceace']" data-type="text" order="ascending"/>
When I get to a change of sourceace and targetace I need to output a count of the number of MoveSuccess elements I have procesed.
I have tried all sorts of combinations of rule. my current attempt loks like this using the variable ace (which contains the correct value Naa030 first time).
<xsl:value-of select="count(ancestor::moveBatchResults/descendant:
But I can't get the correct count.
Anyone got any ideas please
<?xml version="1.0" encoding="UTF-8"?>
<moveBatchResults>
<property type="MoveResultCVO">
<property name="moveResults" type="ArrayList">
<property type="MoveFailure">
<property type="MoveVO" name="moveVO">
<property name="movement" type="String">MOVE</property>
<property name="ace" type="String">aa030</property>
<property name="reasonCode" type="null"/>
</property>
<property name="errorMessage" type="String">Target ace must belong to Current ace</property>
</property>
<property type="MoveSuccess">
<property name="movement" type="String">MOVE</property>
<property name="Balance" type="Double">-361344.46</property>
<property name="cofElementInformationVOs" type="ArrayList">
<property type="ElementInformationVO">
<property name="Balance" type="Double">-28545.43</property>
<property name="clasNumber" type="String">10126584</property>
</property>
<property type="ElementInformationVO">
<property name="Balance" type="Double">-92196.87999999999</property>
<property name="clasNumber" type="String">10126584</property>
</property>
<property type="ElementInformationVO">
<property name="Balance" type="Double">-240602.15000000002</property>
<property name="clasNumber" type="String">10126584</property>
</property>
</property>
<property name="mfNo" type="String">aa550U-00517</property>
<property name="targetace" type="String">aa030</property>
<property name="sourceace" type="String">aa029</property>
</property>
<property type="MoveSuccess">
<property name="movement" type="String">MOVE</property>
<property name="Balance" type="Double">1.48929757415317E-11</property>
<property name="cofElementInformationVOs" type="ArrayList">
<property type="ElementInformationVO">
<property name="Balance" type="Double">-7.275957614183426E-12</property>
<property name="clasNumber" type="String">10115129</property>
</property>
<property type="ElementInformationVO">
<property name="Balance" type="Double">2.546585164964199E-11</property>
<property name="clasNumber" type="String">10115129</property>
</property>
<property type="ElementInformationVO">
<property name="Balance" type="Double">-5.684341886080801E-13</property>
<property name="clasNumber" type="String">10115129</property>
</property>
<property type="ElementInformationVO">
<property name="capitalBalance" type="Double">-2.7284841053187847E-12</property>
<property name="clasNumber" type="String">10115129</property>
</property>
</property>
<property name="mfNo" type="String">ooo50T-00133</property>
<property name="targetace" type="String">aa030</property>
<property name="sourceace" type="String">N</property>
</property>
<property type="MoveSuccess">
<property name="movement" type="String">MOVE</property>
<property name="Balance" type="Double">-2.0463630789890885E-12</property>
<property name="cofElementInformationVOs" type="ArrayList">
<property type="ElementInformationVO">
<property name="Balance" type="Double">-2.0463630789890885E-12</property>
<property name="clasNumber" type="String">10119258</property>
</property>
</property>
<property name="mfNo" type="String">lll50K-00023</property>
<property name="targetace" type="String">aa030</property>
<property name="sourceace" type="String">N</property>
</property>
</property>
</property>
</moveBatchResults>