INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How do I get TicketDate from xml document?

How do I get TicketDate from xml document?

(OP)
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.

The output can look like this.

CODE --> xml

<Charge>
    <Citation>
        <TicketDate>2014-03-26</TicketDate>
    </Citation>
</Charge> 

Desired output

CODE --> xml

<ext:Charge>
    <ext:Citation>
        <nc:ActivityDate>2014-03-26</nc:ActivityDate>
    </ext:Citation>
</ext:Charge> 

xml

CODE --> xml

<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 --> xslt

<xsl:template name="ChargeDetails">
         <ext:Citation>
        <xsl:if test="@Stage='Citation Issued'">
        <!--<xsl:for-each select="../../DispositionEvent[Disposition/@ChargeHistoryID=current()/@ChargeHistoryID][1]">-->
        <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> 

RE: How do I get TicketDate from xml document?

I am not as familiar with this particular corner of LegalXML. (I am blundering around in CivilCase land right now.)

Are you saying that there can be multiple <Citation> with an <Integration>? Are you trying to relate from a particular <Charge> to find all of the <Citation> that pertain to that <Charge>?

Several confusing points. What is the context node for the called template you have provided? Most of your <xsl:value-of> XPath expressions refer to non-existing nodes in the example XML.

Sorry, but I think you need to provide a better problem statement.

Tom Morrison
Hill Country Software

RE: How do I get TicketDate from xml document?

momo2000, any additional insight on this?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close