title: Couchbase how to query an array
body: <p>If I have Couchbase documents that look like this:</p>
  
  <pre><code>{
    "history": {
      "id": "123",
      "date": "today",
      "status_history": [
        {
          "code": "0",
          "message": "success",
          "status": "complete"
        }
      ],
      "other": "other"
    }
  }
  </code></pre>
  
  <p>If I want to get all the documents from today I can do something like <code>select * from 'my_bucket' where history.date = "today"</code></p>
  
  <p>But how can I get something like status from status_history that is in an array structure?</p>
  
  <pre><code>select * from 'my_bucket' where history.status_history. status?? = "complete"
  </code></pre>