How do I get TicketDate from xml doc?

Here should go questions about transforming XML with XSLT and FOP.
winkimjr2
Posts: 62
Joined: Thu Jun 26, 2014 9:00 pm

How do I get TicketDate from xml doc?

Post by 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>