DocumentDB Query documents where Array_Length > 1
<p>I have sets of documents that looks like this:</p>

<pre><code>[
  {
    "Name": "Document1",
    "Properties": {
      "Property1": [
        "Value1",
        "Value2",
        "Value3",
      ]
    },
    "Tags": null
  },
  {
    "Name": "Document2",
    "Properties": {
      "Property1": [
        "Value1",
      ]
    },
    "Tags": null
  },
  {
    "Name": "Document3",
    "Properties": {
      "Property1": [
        "Value1",
        "Value2",
      ]
    "Property2": [
        "Value1",
      ]
    },
    "Tags": null
  }
]
</code></pre>

<p>I need to query for any documents where the the <code>Property1</code> array within the Properties node has more that 1 item. In my example above I would expect to only get back <code>Document1</code> and <code>Document3</code>. I have spent a great deal of time experimenting with the Array_Contains syntax but keep coming up short. Here is what my latest attempt looks like:</p>

<pre><code>SELECT * FROM Docs d WHERE ARRAY_LENGTH([d.Properties, 'Property1']) &gt; 1
</code></pre>

<p>But with my syntax I get back every document.</p>