Myujth

I am new to xsl. I understand that some similar questions have been asked, but I need help since I can't figure out what was wrong with my code. I have xml transactions file. I want to ,first, group by date, then sort each group of transactions by time

I have this xml

<History>
 <ShareLoanResults>
 <Account>123</Account>
 <PostingDt>20180718</PostingDt>
 <PostingTime>215642</PostingTime>
 <AmtLoan>000000000</AmtLoan>
 <AmtShare>000000001</AmtShare>
 <AmtInt>000000000</AmtInt>
 <Balance>000000487</Balance>
 <Description />
 </ShareLoanResults>
 <ShareLoanResults>
 <Account>123</Account>
 <PostingDt>20180719</PostingDt>
 <PostingTime>215650</PostingTime>
 <AmtLoan>000000000</AmtLoan>
 <AmtShare>000000003</AmtShare>
 <AmtInt>000000000</AmtInt>
 <Balance>000000494</Balance>
 <Description />
 </ShareLoanResults>
 <ShareLoanResults>
 <Account>123</Account>
 <PostingDt>20180719</PostingDt>
 <PostingTime>215640</PostingTime>
 <AmtLoan>000000000</AmtLoan>
 <AmtShare>000000002</AmtShare>
 <AmtInt>000000000</AmtInt>
 <Balance>000000489</Balance>
 <Description />
 </ShareLoanResults>
 <ShareLoanResults>
 <Account>123</Account>
 <PostingDt>20180717</PostingDt>
 <PostingTime>215641</PostingTime>
 <AmtLoan>000000000</AmtLoan>
 <AmtShare>000000004</AmtShare>
 <AmtInt>000000000</AmtInt>
 <Balance>000000486</Balance>
 <Description />
 </ShareLoanResults>
</History>

I am looking for this result

<History>
<ShareLoanResults>
 <Order>1</Order>
 <Account>123</Account>
 <PostingDt>20180717</PostingDt>
 <PostingTime>215641</PostingTime>
 <Amount>4</Amount>
</ShareLoanResults>
<ShareLoanResults>
 <Order>1</Order>
 <Account>123</Account>
 <PostingDt>20180718</PostingDt>
 <PostingTime>215642</PostingTime>
 <Amount>1</Amount>
</ShareLoanResults>
<ShareLoanResults>
 <Order>1</Order>
 <Account>123</Account>
 <PostingDt>20180719</PostingDt>
 <PostingTime>215640</PostingTime>
 <Amount>3</Amount>
</ShareLoanResults>
<ShareLoanResults>
 <Order>2</Order>
 <Account>123</Account>
 <PostingDt>20180719</PostingDt>
 <PostingTime>215650</PostingTime>
 <Amount>3</Amount>
</ShareLoanResults>
</History>

Here is my xsl

<xsl:stylesheet version='2.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'>
<xsl:output method="xml" omit-xml-declaration="no" />

<xsl:template match="/"> 
<xsl:copy>
 <xsl:for-each-group select="History/ShareLoanResults" group-by="PostingDt">
 <xsl:for-each select="current-group()">
 <xsl:sort select="PostingTime" order="ascending"/>
 <ShareLoanResults>
 <Order>
 <xsl:value-of select="position()"/>
 </Order>
 <Account>
 <xsl:value-of select="Account"/>
 </Account>
 <PostingDt>
 <xsl:value-of select="PostingDt"/>
 </PostingDt> 
 <PostingTime>
 <xsl:value-of select="PostingTime"/>
 </PostingTime> 
 <Amount>
 <xsl:value-of select="format-number(AmtShare,'#.000000')"/>
 </Amount>
 </ShareLoanResults>
 </xsl:for-each> 
 </xsl:for-each-group>
</xsl:copy>
</xsl:template>

</xsl:stylesheet>

However, I am getting exception: javax.xml.transform.TransformerException: Could not find function: current-group

If I remove the <xsl:for-each-group select="current-group()"> and its corresponding closed tag, I get empty result below

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<ShareLoanResults><Order/><Account/><PostingDt/><PostingTime/><Amount>NaN</Amount></ShareLoanResults>

Could someone please tell me what I did wrong and/or was missing?
Thanks!

As mentioned by our XSLT gurus, you do not need any grouping or even a 2.0 processor. Simply sort by date and time, and have Order node count following siblings with same date:

<xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'>
 <xsl:output method="xml" omit-xml-declaration="no" indent="yes" />
 <xsl:strip-space elements="*"/>

 <xsl:template match="/History"> 
 <xsl:copy> 
 <xsl:apply-templates select="ShareLoanResults">
 <xsl:sort select="PostingDt"/>
 <xsl:sort select="PostingTime"/>
 </xsl:apply-templates>
 </xsl:copy>
 </xsl:template>

 <xsl:template match="ShareLoanResults"> 
 <xsl:variable name="curr_dt" select="PostingDt"/>
 <xsl:copy>
 <Order>
 <xsl:value-of select="count(following-sibling::*[PostingDt=$curr_dt])+1"/>
 </Order>
 <Account>
 <xsl:value-of select="Account"/>
 </Account>
 <PostingDt>
 <xsl:value-of select="PostingDt"/>
 </PostingDt> 
 <PostingTime>
 <xsl:value-of select="PostingTime"/>
 </PostingTime> 
 <Amount>
 <xsl:value-of select="format-number(AmtShare,'#.000000')"/>
 </Amount>
 </xsl:copy>
 </xsl:template>
</xsl:stylesheet>

XSLT Demo