How do I get GRD with lowest InternalPartyID?

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 GRD with lowest InternalPartyID?

Post by winkimjr2 » Thu Mar 19, 2015 11:57 pm

I have xslt that I am running using xml doc and I want to display the GRD with the lowest InternalPartyID.
The conditions are Find all Case/CaseParty/Connection@Word='GRD' and Case/CaseParty/Connection/RemoveDate does not exist.
Then select CaseParty that has the lowest CaseParty@InternalPartyID. After that use the selected Guardian to create location structure. Location is a template in my xslt code.
How do I do this?
Here is the output I want

Code: Select all

<ext:Guardian>
<ext:PersonBirthDate ext:approximateDateIndicator="false" ext:currentIndicator="true">1974-09-27</ext:PersonBirthDate>
<nc:PersonName>
<nc:PersonGivenName>Cindee</nc:PersonGivenName>
<nc:PersonMiddleName/>
<nc:PersonSurName>Truesdell</nc:PersonSurName>
<nc:PersonNameSuffixText/>
<nc:PersonFullName>Truesdell, Cindee</nc:PersonFullName>
</nc:PersonName>
<ext:PersonRaceCode>H</ext:PersonRaceCode>
<nc:PersonSexCode>F</nc:PersonSexCode>
</ext:Guardian>
Here is my xml code

Code: Select all

<Case InternalID="1617088771" ID="12122866" xmlns:user="http://tylertechnologies.com">
<CaseParty ID="16769136" InternalCasePartyID="1634788175" InternalPartyID="1614672231">
<SendNotice>true</SendNotice>
<RestrictView>false</RestrictView>
<ObservedRace Word="H">Native Hawaiian or Other Pacific Islander</ObservedRace>
<Connection Word="GRD" BaseConnection="GD" ID="36381880" InternalCasePartyConnectionID="1636470565">
<Description>Guardian</Description>
<TimestampCreate>2/18/2015 4:27:54 PM</TimestampCreate>
<DateAdded>02/18/2015</DateAdded>
</Connection>
<CasePartyName Current="true" ID="10052180" InternalNameID="1615525304">
<NameType>Standard</NameType>
<NameFirst>Cindee</NameFirst>
<NameLast>Truesdell</NameLast>
<FormattedName>Truesdell, Cindee</FormattedName>
</CasePartyName>
<TimestampCreate>2/18/2015 4:27:54 PM</TimestampCreate>
</CaseParty>
<CaseParty ID="16769137" InternalCasePartyID="1634788180" InternalPartyID="1614672232">
<SendNotice>true</SendNotice>
<RestrictView>false</RestrictView>
<ObservedRace Word="H">Native Hawaiian or Other Pacific Islander</ObservedRace>
<Connection Word="GRD" BaseConnection="GD" ID="36381885" InternalCasePartyConnectionID="1636470570">
<Description>Guardian</Description>
<TimestampCreate>2/18/2015 4:35:31 PM</TimestampCreate>
<DateAdded>02/18/2015</DateAdded>
</Connection>
<CasePartyName Current="true" ID="10052181" InternalNameID="1615525305">
<NameType>Standard</NameType>
<NameFirst>Regina</NameFirst>
<NameLast>Sedar</NameLast>
<FormattedName>Sedar, Regina</FormattedName>
</CasePartyName>
<TimestampCreate>2/18/2015 4:35:31 PM</TimestampCreate>
</CaseParty>
</Case>
http://files.engineering.com/download.a ... ltCode.xml

winkimjr2
Posts: 62
Joined: Thu Jun 26, 2014 9:00 pm

Re: How do I get GRD with lowest InternalPartyID?

Post by winkimjr2 » Mon Mar 23, 2015 8:42 pm

I have withdrawn this question. Should I delete it?

Post Reply