How do I get GRD with lowest InternalPartyID?

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

How do I get GRD with lowest InternalPartyID?

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.aspx?folder=30264f64-0e34-4621-8696-f72e330fa2db&file=mypoxsltCode.xml
winkimjr2
Posts: 53

Re: How do I get GRD with lowest InternalPartyID?

Mon Mar 23, 2015 8:42 pm

I have withdrawn this question. Should I delete it?

Return to “XSLT and FOP”

Who is online

Users browsing this forum: No registered users and 1 guest