Examples:

This processor produces one attribute or FlowFile per XQueryResult. If only one attribute or FlowFile is desired, the following examples demonstrate how this can be achieved using the XQuery language. The examples below reference the following sample XML:

		
  <?xml version="1.0" encoding="UTF-8"?>
  <?xml-stylesheet type="text/xsl" href="foo.xsl"?>
  <ns:fruitbasket xmlns:ns="http://namespace/1">
    <fruit taste="crisp">    
      <!-- Apples are my favorite-->   
      <name>apple</name>   
      <color>red</color>  
    </fruit>  
    <fruit>   
      <name>apple</name>   
      <color>green</color>  
    </fruit>  
    <fruit>   
      <name>banana</name>   
      <color>yellow</color>  
    </fruit>  
    <fruit taste="sweet">   
      <name>orange</name>   
      <color>orange</color>  
    </fruit>  
    <fruit>   
      <name>blueberry</name>   
      <color>blue</color>  
    </fruit>  
      <fruit taste="tart">   
      <name>raspberry</name>   
      <color>red</color>  
    </fruit>  
    <fruit>   
      <name>none</name>    
      <color/>  
    </fruit>
  </ns:fruitbasket>

        

• XQuery to return all "fruit" nodes individually (7 Results):
  • //fruit
• XQuery to return only the first "fruit" node (1 Result):
  • //fruit[1]
• XQuery to return only the last "fruit" node (1 Result):
  • //fruit[count(//fruit)]
• XQuery to return all "fruit" nodes, wrapped in a "basket" tag (1 Result):
  • <basket>{//fruit}</basket>
• XQuery to return all "fruit" names individually (7 Results):
  • //fruit/text()
• XQuery to return only the first "fruit" name (1 Result):
  • //fruit[1]/text()
• XQuery to return only the last "fruit" name (1 Result):
  • //fruit[count(//fruit)]/text()
• XQuery to return all "fruit" names as a comma separated list (1 Result):
  • string-join((for $x in //fruit return $x/name/text()), ', ')
• XQuery to return all "fruit" colors and names as a comma separated list (1 Result):
  • string-join((for $y in (for $x in //fruit return string-join(($x/color/text() , $x/name/text()), ' ')) return $y), ', ')
• XQuery to return all "fruit" colors and names as a comma separated list (1 Result):
  • string-join((for $y in (for $x in //fruit return string-join(($x/color/text() , $x/name/text()), ' ')) return $y), ', ')
• XQuery to return all "fruit" colors and names as a new line separated list (1 Result):
  • string-join((for $y in (for $x in //fruit return string-join(($x/color/text() , $x/name/text()), ' ')) return $y), '\n')