title: DocumentDB Query documents where Array_Length > 1
body: <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>