title: how to query cosmos db array to find exact match for all the items
body: <p>I have below data in cosmos db</p>
  <pre><code>[
  {
      &quot;id&quot;: &quot;123&quot;,
      &quot;threadId&quot;: &quot;1234&quot;,
      &quot;participantId&quot;: [
          &quot;0000000e-1a91-7ff4-28f4-343a0d006def&quot;,
          &quot;0000000e-1a9a-a08e-6a0b-343a0d006671&quot;
      ]
  },
  {
      &quot;id&quot;: &quot;1234&quot;,
      &quot;threadId&quot;: &quot;1234&quot;,
      &quot;participantId&quot;: [
          &quot;0000000e-1a91-7ff4-28f4-343a0d006def&quot;,
          &quot;0000000e-1a98-1dd4-85f4-343a0d009ba3&quot;
      ]
  }
  </code></pre>
  <p>]</p>
  <p>So i am looking for a query to find exact match of Array Items for e.g in c# I will pass list of Participant i.e. 0000000e-1a91-7ff4-28f4-343a0d006def, 0000000e-1a9a-a08e-6a0b-343a0d006671 and it should look for exact match and it should not bring data from other participant array. As here it has one match</p>