title: Query/Filter CosmosDB Core SQL by key name value
body: <p>I have the following data structure (to be able to query and filter by day):</p>
  <pre><code>&quot;id&quot;: &quot;someId&quot;,
  &quot;dailyPlan&quot;: {
      &quot;2020-04-07&quot;: {
          &quot;activityCategoryOne&quot;: {
              &quot;activityOne&quot;: &quot;someID&quot;,
              &quot;activityTwo&quot;: &quot;someIDTwo&quot;
          }
      }
  }
  </code></pre>
  <p>So now I want to query only the items from the past and the next two weeks. But I have no idea how I can query the key name (&quot;2020-04-07&quot;).
  Is this possible and if so could you give me a hint or a link to the documentation as I couldn't find anything about it in my research.</p>
  <p>Thank you very much!</p>
  <p>Best,
  Tixamaster</p>