title: The SQL query text exceeded the maximum limit of 30720 characters in Azure CosmosDB
body: <p>I have a query where I use an array with an "IN" style setup.</p>
  
  <pre><code>var builder = Builders&lt;Transaction&gt;.Filter;
          var filter = builder.Eq("App", app) 
                        &amp; builder.In("TransactionId", incomingIds);
          List&lt;string&gt; existingTransactions = collection
              .Find(filter)
              .Project(x =&gt; x.TransactionId)
              .ToList();
  </code></pre>
  
  <p>A while back this started to throw the error below and I had reduce my batch-size significantly to avoid the error.</p>
  
  <p>Command delete failed: Errors encountered exception while executing function. </p>
  
  <p>Error while querying documents
  Code: SC3020
  The SQL query text exceeded the maximum limit of 30720 characters.</p>
  
  <p>Microsoft.Azure.Documents.Common/1.20.0.0.</p>
  
  <p>Was this limitation a "feature" added by Microsoft at some point?</p>
  
  <p>I can't seem to find any info except this feedback suggestion:
  <a href="https://feedback.azure.com/forums/263030-azure-cosmos-db/suggestions/32665819-increase-query-maximum-character-limit-for-cosmo-m" rel="nofollow noreferrer">https://feedback.azure.com/forums/263030-azure-cosmos-db/suggestions/32665819-increase-query-maximum-character-limit-for-cosmo-m</a></p>