How do I get TicketDate from xml doc?

Here should go questions about transforming XML with XSLT and FOP.
winkimjr2
Posts: 53

How do I get TicketDate from xml doc?

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

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>

Return to “XSLT and FOP”

Who is online

Users browsing this forum: No registered users and 1 guest