title: Query CosmosDB document using C#
body: <p>I have documents stored in cosmos db, I have multiple documents for a same "stationkey"(partition key), in this example stationkey "ABC" has more than one documents with "yymm" has "2018-02" &amp; "2018-01" e.t.c, </p>
  
  <p>query that i am trying is get all "avg" &amp; "dd" fields along with "yymm" for the given stationkey and yymm filter combination </p>
  
  <p><a href="https://i.stack.imgur.com/CFPdx.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CFPdx.jpg" alt="JSON Document"></a></p>
  
  <p>I am trying to query using C#, I am trying to get "avg", "dd" &amp; "yymm" fields from "data" array, the query that I have written is giving entire "data" array.</p>
  
  <pre><code>var weatherQuery = this.docClient.CreateDocumentQuery&lt;WeatherStation&gt;(docUri, queryOptions)
              .Where(wq =&gt; wq.stationName == stationKey &amp;&amp; lstYearMonthFilter.Contains(wq.yearMonth))
              .Select(s =&gt; s.data);
  </code></pre>
  
  <p>what is the best way to query specific fields in from a document array?</p>