max number of elements

JohnBampton · January 12th, 2011, 07:55 AM

Hi All,

Code:

<root>
<ITEMDETAILS>
<LOTDETAILS></LOTDETAILS>
<LOTDETAILS></LOTDETAILS>
</ITEMDETAILS>

<ITEMDETAILS>
<LOTDETAILS></LOTDETAILS>
</ITEMDETAILS>
</root>

I need to find the maximum number of LOTDETAILS elements per one ITEMDETAILS element. In this case the answer would be 2. I can only use xpath 2.0

Thanks.

Martin Honnen · January 12th, 2011, 08:07 AM

Try

Code:

max(/root/ITEMDETAILS/count(LOTDETAILS))

JohnBampton · January 12th, 2011, 09:11 AM

Great work, thanks