How do I get TicketDate from xml doc?
Posted: Fri May 08, 2015 4:40 pm
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
xml document
xslt
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>
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>
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>