title: Document Db query filter for an attribute that contains an array
body: <p>With the sample json shown below, am trying to retrieve all documents that contains atleast one category which is array object wrapped <em>underneath Categories</em> that has the text value 'drinks' with the following query but the returned result is empty. Can someone help me get this right? </p>
  
  <pre><code>SELECT items.id
  ,items.description
  ,items.Categories
  FROM items
  WHERE ARRAY_CONTAINS(items.Categories.Category.Text, "drink")
  </code></pre>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>{
    "id": "1dbaf1d0-6549-11a0-88a8-001256957023",
    "Categories": {
      "Category": [{
        "Type": "GS1",
        "Id": "10000266",
        "Text": "Stimulants/Energy Drinks Ready to Drink"
      }, {
        "Type": "GS2",
        "Id": "10000266",
        "Text": "Healthy Drink"
      }]
    }
  },</code></pre>
  </div>
  </div>
  
  <em>Note: The json is a bit wierd to have the array wrapped by an object itself - this json was converted from a XML hence the result. So please assume I do not have any control over how this object is saved as json</em></p>