How do I get GRD with lowest InternalPartyID?

[winkimjr2]

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]

I have withdrawn this question. Should I delete it?