title: Using Cosmos DB how do I query just on the partition key
body: <p>We have a group of related documents all sharing the same partition key.  The thinking  is simply grouping these up should be a case of querying on the partition key and stitching them together.  What am I missing? </p>
  
  <p>So
  Select * from c where c.CustomerId = "500"</p>
  
  <p>Would return say 3 documents,  Address, Sales and Invoices who all have a property named CustomerId , with a value of 500.  </p>
  
  <p>I appreciate its not the primary key and I am purposely omiitng a row key. </p>
  
  <p>Perhaps not splitting the documents is the answer but then the different documents have different TTLs and this would then becone problematic, wouldnt it( </p>
  
  <p>CustomerId is the partition key.</p>
  
  <p>The ms docs say this is possible (citing a city = seattle ) example.  Where their partitionkey is city....</p>
  
  <p>So, what am I missing, a complete misunderstaning of querying is cosmos ? (i can say I know a partition key is used to break up related data into partitions) I didnt know this made it an unqueryable aspect.</p>
  
  <p>Also I can query with partition key and rowkey no problem. </p>
  
  <p>EDIT 2:</p>
  
  <p>This works:</p>
  
  <p>SELECT * FROM c WHERE c.CustomerId > "499" AND c.CustomerId &lt; "501"</p>