Grabbing the highest value from multiple fields in XSLT

Question

I am looking to have xslt grab every occurance of a field, in this case //field and then find the largest value held and output that.. would something like the below work? I have used something similair before but i am a little unsure on sort select'"value"

<xsl:choose>
    <xsl:when test="count(//field1) &gt; 0">
        <xsl:for-each select="//field1">
            <xsl:sort select="value" order="descending" />
                <xsl:if test="position() = 1">
                    <xsl:value-of select="."/>
                </xsl:if>
        </xsl:for-each>
    </xsl:when>
    <xsl:otherwise>0</xsl:otherwise>
</xsl:choose>

the xml will be in a format something like below

<1>
   <2>
       <field>125</field>
   </2>
</1>
<1>
   <2>
       <field>10</field>
   </2>
</1>
<1>
   <2>
       <field>0</field>
   </2>
</1>

(Not my choice of format for the XML, but it is what i have been dumped with to work with... in msot cases this field appears 28 times, but i always need the highest value.

Mitya · Accepted Answer · 2014-01-30 09:38:43Z

1

Not sure about XSLT 2 but EXSLT provides math:max.

<h1>Max value is <xsl:value-of select='math:max(//field)' /></h1>

http://www.xmlplayground.com/3D3tUE

answered Jan 30, 2014 at 9:38

Mitya

34.8k15 gold badges70 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jonathan Spickernell Over a year ago

Perfect, using the math namespace has worked a treat, thank you so much!

Daniel Haley · Accepted Answer · 2014-01-30 09:37:07Z

1

Try using max()...

<xsl:value-of select="max(//field)"/>

answered Jan 30, 2014 at 9:37

Daniel Haley

53.1k7 gold badges75 silver badges97 bronze badges

3 Comments

Jonathan Spickernell Over a year ago

javax.xml.transform.TransformerException: org.xml.sax.SAXException: Could not find function: max javax.xml.transform.TransformerException: Could not find function: max, i will have a look around for some examples of the field see if i missed anything

Daniel Haley Over a year ago

@JonathanSpickernell- You're not using an XSLT 2.0 processor. I suggest removing the 2.0 tag. Also, you can change your xsl:sort to <xsl:sort select="." order="descending" /> and it should work.

Jonathan Spickernell Over a year ago

As far as i am aware this is using XSLT 2.0 but i will remove and then double check whats running on the service.

Collectives™ on Stack Overflow

Grabbing the highest value from multiple fields in XSLT

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related