How do I output all child elements for Charge node for each Charge?

winkimjr2 · September 21st, 2016, 03:28 PM

I would like to output all Charge elements for all Charges, when OffenseID/ID ID=PENDING.
The important thing to note is that the element OffenseCite will be output as
StatuteNumber

Code:

<StatuteNumber>169A.20.1(5)</StatuteNumber>

Sample Output for each Charge should look like this. I did not include all elements

Code:

<Charge>
<ReportingAgency>xyz</ReportingAgency>
<Statute>
<StatuteDescription>TRAFFIC - DWI - OPERATE MOTOR VEHICLE - ALCOHOL CONCENTRATION 0.08 WITHIN 2 HOURS</StatuteDescription>
<StatuteNumber>169A.20.1(5)</StatuteNumber>
</Statute>
</Charge>

<b>Input xml doc</b>

Code:

<?xml version="1.0" encoding="UTF-8"?>
<Envelope xmlns:NS1="http://www.w3.org/2003/05/soap-envelope">
	<Body>
		<TabChargeDocument>

			<Charge>
				<ChargeSequenceID>
					<ID>1</ID>
				</ChargeSequenceID>
				<OffenseID>
					<ID>PENDING</ID>
				</OffenseID>
				<OffenseCite>169A.27.1</OffenseCite>
				<OffenseDescriptionText>TRAFFIC - DWI - FOURTH-DEGREE DRIVING WHILE IMPAIRED; DESCRIBED</OffenseDescriptionText>
				<OffenseDate>2016-09-18</OffenseDate>
				<OffenseTime>00:22:00</OffenseTime>
				<OffenseDatesOnOrAbout>false</OffenseDatesOnOrAbout>
				<SeverityLevelText>Misdemeanor</SeverityLevelText>
				<MinnesotaOffenseCode>NBR</MinnesotaOffenseCode>
				<Report>
					<ReportingAgencyORI>
						<ID>MNMHP0400</ID>
					</ReportingAgencyORI>
					<ReportingAgencyControlNumber>
						<ID>16510299</ID>
					</ReportingAgencyControlNumber>
					<ReportingOfficial>
						<OfficerBadgeNumber>
							<ID>176</ID>
						</OfficerBadgeNumber>
						<OfficerNameText>UTES</OfficerNameText>
					</ReportingOfficial>
				</Report>
				<CommunityOfOffenseText>Brooklyn Park</CommunityOfOffenseText>
			</Charge>
			<Charge>
				<ChargeSequenceID>
					<ID>2</ID>
				</ChargeSequenceID>
				<OffenseID>
					<ID>PENDING</ID>
				</OffenseID>
				<OffenseCite>169A.20.1(5)</OffenseCite>
				<OffenseDescriptionText>TRAFFIC - DWI - OPERATE MOTOR VEHICLE - ALCOHOL CONCENTRATION 0.08 WITHIN 2 HOURS</OffenseDescriptionText>
				<OffenseDate>2016-09-18</OffenseDate>
				<OffenseTime>00:22:00</OffenseTime>
				<OffenseDatesOnOrAbout>false</OffenseDatesOnOrAbout>
				<SeverityLevelText>Misdemeanor</SeverityLevelText>
				<Report>
					<ReportingAgencyORI>
						<ID>MNMHP0400</ID>
					</ReportingAgencyORI>
					<ReportingAgencyControlNumber>
						<ID>16510299</ID>
					</ReportingAgencyControlNumber>
					<ReportingOfficial>
						<OfficerBadgeNumber>
							<ID>176</ID>
						</OfficerBadgeNumber>
						<OfficerNameText>UTES</OfficerNameText>
					</ReportingOfficial>
				</Report>
				<CommunityOfOffenseText>Brooklyn Park</CommunityOfOffenseText>
			</Charge>
			<Charge>
				<ChargeSequenceID>
					<ID>3</ID>
				</ChargeSequenceID>
				<OffenseID>
					<ID>PENDING</ID>/Envelope/Body/TabChargeDocument/Charge[3]/OffenseID/ID
				</OffenseID>
				<OffenseCite>169A.20.1(1)</OffenseCite>
				<OffenseDescriptionText>TRAFFIC - DWI - OPERATE MOTOR VEHICLE UNDER INFLUENCE OF ALCOHOL</OffenseDescriptionText>
				<OffenseDate>2016-09-18</OffenseDate>
				<OffenseTime>00:22:00</OffenseTime>
				<OffenseDatesOnOrAbout>false</OffenseDatesOnOrAbout>
				<SeverityLevelText>Misdemeanor</SeverityLevelText>
				<Report>
					<ReportingAgencyORI>
						<ID>MNMHP0400</ID>
					</ReportingAgencyORI>
					<ReportingAgencyControlNumber>
						<ID>16510299</ID>
					</ReportingAgencyControlNumber>
					<ReportingOfficial>
						<OfficerBadgeNumber>
							<ID>176</ID>
						</OfficerBadgeNumber>
						<OfficerNameText>UTES</OfficerNameText>
					</ReportingOfficial>
				</Report>
				<CommunityOfOffenseText>Brooklyn Park</CommunityOfOffenseText>
			</Charge>
		</TabChargeDocument>
		</Body>
</Envelope>

Martin Honnen · September 21st, 2016, 04:46 PM

You can use

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    exclude-result-prefixes="xs"
    version="2.0">
    
    <xsl:param name="id" as="xs:string" select="'PENDING'"/>
    
    <xsl:output indent="yes"/>
    
    <xsl:template match="/">
        <xsl:apply-templates select="//Charge[OffenseID/ID = $id]"></xsl:apply-templates>
    </xsl:template>
    
    <xsl:template match="Charge">
        <xsl:copy>
            <ReportingAgency>
                <xsl:value-of select="Report/ReportingAgencyORI/ID"/>
            </ReportingAgency>
            <Statute>
                <StatuteDescription>
                    <xsl:value-of select="OffenseDescriptionText"/>
                </StatuteDescription>
                <StatuteNumber>
                    <xsl:value-of select="OffenceCite"/>
                </StatuteNumber>
            </Statute>
        </xsl:copy>
    </xsl:template>
</xsl:stylesheet>

which at least shows how to select certain "Charge" elements.