title: Query CosmosDb - where array contains item(s) from array
body: <p>I don't know if there is a word for this, guess there is, but right now I couldn't explain it better than "where array contains item(s) from array".</p>
  
  <p>It might sound weird, but actually it not (I think), and I'm having a hard time figuring out how I can do this in Azure CosmosDB.</p>
  
  <p>Here goes. I have a document like this (simplified):</p>
  
  <pre><code>{
  "id": "2a62fcf4-988f-4ebe-aedc-fb0c664b85d8",
  "Title": "Seks års fængsel for overgreb",    
  "ZipCodes": [
      {
          "Code": "6500",
          "Name": "Vojens",
          "FoundViaTerm": "Vojens"
      },
      {
          "Code": "6400",
          "Name": "Sønderborg",
          "FoundViaTerm": "Sønderborg"
      },
      {
          "Code": "6700",
          "Name": "Esbjerg",
          "FoundViaTerm": "Esbjerg"
      }
  ],
  "_rid": "k1sVAPf7SQAMAAAAAAAAAA==",
  "_self": "dbs/k1sVAA==/colls/k1sVAPf7SQA=/docs/k1sVAPf7SQAMAAAAAAAAAA==/",
  "_etag": "\"00001000-0000-0000-0000-5a14898e0000\"",
  "_attachments": "attachments/",
  "_ts": 1511295374
  </code></pre>
  
  <p>}</p>
  
  <p>Ok, now I want to query documents like this and find all, where ZipCodes.Code is in a list of zipcodes, ex. ('6500', '2700').</p>
  
  <p>I'm puzzle here...</p>
  
  <p>I found the <a href="https://docs.microsoft.com/en-us/azure/cosmos-db/documentdb-sql-query-reference#bk_array_contains" rel="noreferrer">ARRAY_CONTAINS</a> method and it works, if I only come in with one zipcode - my problem is I come with a list.</p>
  
  <p>Hope somebody can help, thanks in advance.</p>