How do I get TicketDate from xml doc?

[winkimjr2]

What I want to do is use the xml document to get the TicketDate. The xml document could have more than one ChargeID. So I have to match the ChargeHistoryID a child of CitationCharge to the ChargeHistoryID a child of Charge. This ensures I get the right TicketDate for the right Charge and Citation.

My xsl code is not displaying TicketDate from xml document.

Desired output

Code: Select all

<ext:Charge>

    <ext:Citation>

        <nc:ActivityDate>2014-03-26</nc:ActivityDate>

    </ext:Citation>

</ext:Charge>

xml document

Code: Select all

<Integration xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:tsg="http://tsgweb.com" xmlns:IXML="http://tsgweb.com" xmlns:CMCodeQueryHelper="urn:CMCodeQueryHelper" PackageID="IXML Case Notification Test" MessageID="67078058" xmlns="">

    <Case InternalID="1616807927" ID="11747370" xmlns:user="http://tylertechnologies.com">

        <Charge ID="10547226" PartyID="16580814" CurrSentenceID="155092098" InternalChargeID="1616447618" InternalPartyID="1614482843" xmlns:reslib="urn:reslib">

            <ChargeOffenseDate>03/26/2014</ChargeOffenseDate>

            <ChargeHistory ChargeHistoryID="41490827" Stage="Citation Issued" CitationEventSequence="1" InternalOffenseHistoryID="1635954992">

                <ChargeNumber>1</ChargeNumber>

            </ChargeHistory>

        </Charge>

    </Case>

    <Citation ID="5131033" xmlns:user="http://tylertechnologies.com">

        <TicketDate>03/26/2014</TicketDate>

        <CitationCharge>

            <ChargeID>10547226</ChargeID>

            <ChargeHistoryID>41490827</ChargeHistoryID>

        </CitationCharge>

    </Citation>

</Integration>

xslt

Code: Select all

<xsl:template name="ChargeDetails">

	<ext:Citation>

    	<xsl:if test="@Stage='Citation Issued'">

    		<xsl:for-each select="/Integration/Citation/CitationCharge[ChargeHistoryID=current()/@ChargeHistoryID][1]">

    		<nc:ActivityDate>

    			<xsl:value-of select="mscef:formatDate(string(../TicketDate))"/> 

    		</nc:ActivityDate>

    		</xsl:for-each>

    	</xsl:if>

    </ext:Citation>

</xsl:template>