fork download
copy 
  1. def jdbcResult = '''<Results>
  2. <ResultSet fetchSize="0">
  3. <Row rowNumber="1">
  4. <INDEX>86</INDEX>
  5. <INDEX.PRICE>22999.0</INDEX.PRICE>
  6. <INDEX.PRICE1>11999.0</INDEX.PRICE1>
  7. </Row>
  8. <Row rowNumber="2">
  9. <INDEX>90</INDEX>
  10. <INDEX.PRICE>2999.0</INDEX.PRICE>
  11. <INDEX.PRICE1>1299.0</INDEX.PRICE1>
  12. </Row>
  13. <Row rowNumber="3">
  14. <INDEX>92</INDEX>
  15. <INDEX.PRICE>3399.0</INDEX.PRICE>
  16. <INDEX.PRICE1>1399.0</INDEX.PRICE1>
  17. </Row>
  18. <Row rowNumber="4">
  19. <INDEX>100</INDEX>
  20. <INDEX.PRICE>3099.0</INDEX.PRICE>
  21. <INDEX.PRICE1>1598.0</INDEX.PRICE1>
  22. </Row>
  23. <Row rowNumber="5">
  24. <INDEX>116</INDEX>
  25. <INDEX.PRICE>3399.0</INDEX.PRICE>
  26. <INDEX.PRICE1>1399.0</INDEX.PRICE1>
  27. </Row>
  28. <Row rowNumber="6">
  29. <INDEX>160</INDEX>
  30. <INDEX.PRICE>3199.0</INDEX.PRICE>
  31. <INDEX.PRICE1>1299.0</INDEX.PRICE1>
  32. </Row>
  33. <Row rowNumber="7">
  34. <INDEX>161</INDEX>
  35. <INDEX.PRICE>2899.0</INDEX.PRICE>
  36. <INDEX.PRICE1>1499.0</INDEX.PRICE1>
  37. </Row>
  38. </ResultSet>
  39. </Results>'''
  40.  
  41. println new XmlSlurper().parseText(jdbcResult).'**'.find {it.name() == 'Row' && it.'INDEX.PRICE'.max()}.'INDEX.PRICE1'.text()
  42.  
Success #stdin #stdout 2.06s 146676KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
11999.0
https://ideone.com/xXgmDh
language:
Groovy (groovy 2.5.6)
created:
4 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!