title: Couchbase Index and N1QL Query
body: <p>I have created a new bucket, FooBar on my couchbase server.</p>
  
  <p>I have a Json Document which is a List with some properties and it is in my couchbase bucket as follows:</p>
  
  <pre><code>[
  {
  "Venue": "Venue1",
  "Country": "AU",
  "Locale": "QLD"
  },
  {
  "Venue": "Venue2",
  "Country": "AU",
  "Locale": "NSW"
    },
  
    {
      "Venue": "Venue3",
      "Country": "AU",
      "Locale": "NSW"
  }
  ]
  </code></pre>
  
  <p>How Do i get the couchbase query to return a List of Locations when using N1QL query.</p>
  
  <p>For instance, SELECT * FROM FooBar WHERE Locale = 'QLD'</p>
  
  <p>Please let me know of any indexes I would need to create as well. Additionally, how can i return only results where the object is of type Location, and not say another object which may have the 'Locale' Property.</p>
  
  <p>Chud</p>
  
  <p>PS - I have also created some indexes, however I would like an unbiased answer on how to achieve this.</p>