how to count the nodes in loop based on condition in xslt

Question

Hi in below xml format i want to get the count of S_fin nodes where F_ba date node is less than 18 monthns of current date. i have a function to get date diffrence here i just want to get the count of nodes which satisfy the conditon.

    <Root>
    <S_fin>
    <FS_ba>
      <F_ba>2013-10-29</F_ba>
      <F_BD desc="Fiscal">001</F_BD>
      <F_BF desc="Thousands">001</F_BF>
      <F_BG desc="Indian Rupee">9</F_BG>
    </FS_ba>
  </S_fin>
  <S_fin>
    <FS_ba>
      <F_ba>2012-10-29</F_ba>
      <F_BD desc="Fiscal">001</F_BD>
      <F_BF desc="Thousands">001</F_BF>
      <F_BG desc="Indian Rupee">9</F_BG>
    </FS_ba>
  </S_fin>
  <S_fin>
    <FS_ba>
        <F_ba>2011-10-29</F_ba>
      <F_BD desc="Fiscal">001</F_BD>
      <F_BF desc="Thousands">001</F_BF>
      <F_BG desc="Indian Rupee">9</F_BG>
    </FS_ba>
  </S_fin>
 <S_fin>
    <FS_ba>
      <F_ba>2013-10-29</F_ba>
      <F_BD desc="Fiscal">001</F_BD>
      <F_BF desc="Thousands">001</F_BF>
      <F_BG desc="Indian Rupee">9</F_BG>
    </FS_ba>
  </S_fin>
</Root>

XSLT 1.0 doesn't have any date functions itself, so are you using an extension function here? It would help if you showed any XSLT you currently have (especially an example of your date difference function). Showing your expected output would also help. Thank you! — Tim C
– Tim C, Commented Dec 8, 2014 at 8:31

fly_ua · Accepted Answer · 2014-12-08 08:34:09Z

1

In xslt it will look like that.

Add reference to your function in square brackets instead of checking for non-empty

    <xsl:template match="@* | node()">
          <cnt>
            <xsl:value-of select="count(S_fin[FS_ba/F_ba != ''])"/>
          </cnt>
     </xsl:template>

answered Dec 8, 2014 at 8:34

fly_ua

1,0548 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to count the nodes in loop based on condition in xslt

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related