title: Querying an embedded list in OrientDB
body: <p>I have a document in my OrientDB database (version 1.0.1), with a structure largely like this:</p>
  
  <pre><code>{
      "timestamp": "...",
      "duration": 665,
      "testcases": [
          {
              "testName": "test01",
              "type": "ignore",
              "filename": "tests/test1.js"
          },
          {
              "iterations": 1,
              "runningTime": 45,
              "testName": "test02",
              "type": "pass",
              "filename": "tests/test1.js"
          },
          ...
          {
              "testName": "test05",
              "type": "ignore",
              "filename": "tests/test1.js"
          }
      ]
  }
  </code></pre>
  
  <p>How can I query across the entire list, eg. if I want to find all documents that contain a testcase with the type "ignore"?</p>
  
  <p>I've attempted the following query </p>
  
  <pre><code>select from testresult where testcases['type'] = 'ignore'
  </code></pre>
  
  <p>but this results in a <code>NumberFormatException</code>. </p>
  
  <pre><code>select from testresult where testcases[0]['type'] = 'ignore'
  </code></pre>
  
  <p>works, but obviously only looks at the first list element of each document.</p>
  
  <pre><code>select from testresult where testcases contains(type = 'ignore')
  </code></pre>
  
  <p>Doesn't provide any results, but the query is accepted as valid.</p>
  
  <p><strong>Update:</strong> 
  The following query works as intended, if the testcases are stored as separate documents instead of as an embedded list.</p>
  
  <pre><code>select from testresult where testcases contains (type = 'ignore')
  </code></pre>