title: Dynamically compare Rest XML/JSON response and JDBC using groovy array in SoapUI
body: <p>In SoapUI, I have a JDBC Test Step that returns the following data:</p>
  
  <pre><code>&lt;Results&gt;
  &lt;ResultSet fetchSize="128"&gt;
      &lt;Row rowNumber="1"&gt;
          &lt;ID&gt;1&lt;/ID&gt;
          &lt;NAME&gt;TestName1&lt;/NAME&gt;
          &lt;DESCRIPTION/&gt;
          &lt;TYPE&gt;Bool&lt;/TYPE&gt;
          &lt;ISPRODUCTTAG&gt;true&lt;/ISPRODUCTTAG&gt;
          &lt;ISLOCATIONTAG&gt;false&lt;/ISLOCATIONTAG&gt;
          &lt;SUBSECTION&gt;Default Sub Section&lt;/SUBSECTION&gt;
          &lt;SECTION&gt;Default Section&lt;/SECTION&gt;
          &lt;SUBGROUP&gt;Default Sub Group&lt;/SUBGROUP&gt;
          &lt;GROUP&gt;Default Group&lt;/GROUP&gt;
      &lt;/Row&gt;
      &lt;Row rowNumber="2"&gt;
          &lt;ID&gt;2&lt;/ID&gt;
          &lt;NAME&gt;TestName2&lt;/NAME&gt;
          &lt;DESCRIPTION/&gt;
          &lt;TYPE&gt;Bool&lt;/TYPE&gt;
          &lt;ISPRODUCTTAG&gt;true&lt;/ISPRODUCTTAG&gt;
          &lt;ISLOCATIONTAG&gt;false&lt;/ISLOCATIONTAG&gt;
          &lt;SUBSECTION&gt;Default Sub Section&lt;/SUBSECTION&gt;
          &lt;SECTION&gt;Default Section&lt;/SECTION&gt;
          &lt;SUBGROUP&gt;Default Sub Group&lt;/SUBGROUP&gt;
          &lt;GROUP&gt;Default Group&lt;/GROUP&gt;
      &lt;/Row&gt;
      &lt;/Row&gt;
  &lt;/ResultSet&gt;
  </code></pre>
  
  <p></p>
  
  <p>I have an REST API XML Response that contains the following data:</p>
  
  <pre><code>    &lt;ArrayOfTagInfo&gt;
     &lt;TagInfo id="1" name="TestName1" type="Bool" isProductTag="true" isLocationTag="false" subsection="Default Sub Section" section="Default Section" subgroup="Default Sub Group" group="Default Group"/&gt;
     &lt;TagInfo id="2" name="TestName2" type="Bool" isProductTag="true" isLocationTag="false" subsection="Default Sub Section" section="Default Section" subgroup="Default Sub Group" group="Default Group"/&gt;
  &lt;/ArrayOfTagInfo&gt;
  </code></pre>
  
  <p>I would like to be able to compare(assert) both the Database Values and the Response Values (response can be in XML or JSON depending on the Request Accept Header) using groovy arrays if possible as the data returned from the database can be very large.</p>
  
  <p>Can anyone help?</p>