title: Find documents with empty string value on elasticsearch
body: <p>I've been trying to filter with elasticsearch only those documents that contains an empty string in its body. So far I'm having no luck. </p>
  
  <p>Before I go on, I should mention that I've already tried the <strong>many</strong> "solutions" spread around the Interwebz and StackOverflow.</p>
  
  <p>So, below is the query that I'm trying to run, followed by its counterparts:</p>
  
  <pre><code>{
      "query": {
          "filtered":{
              "filter": {
                  "bool": {
                      "must_not": [
                          {
                              "missing":{
                                  "field":"_textContent"
                              }
                          }
                      ]
                  }
              }
          }
      }
  }
  </code></pre>
  
  <p>I've also tried the following:</p>
  
  <pre><code> {
      "query": {
          "filtered":{
              "filter": {
                  "bool": {
                      "must_not": [
                          {
                              "missing":{
                                  "field":"_textContent",
                                  "existence":true,
                                  "null_value":true
                              }
                          }
                      ]
                  }
              }
          }
      }
  }
  </code></pre>
  
  <p>And the following:</p>
  
  <pre><code>   {
      "query": {
          "filtered":{
              "filter": {
                      "missing": {"field": "_textContent"}
              }
          }
      }
  }
  </code></pre>
  
  <p>None of the above worked. I get an empty result set when I know for sure that there are records that contains an empty string field.</p>
  
  <p>If anyone can provide me with any help at all, I'll be very grateful.</p>
  
  <p>Thanks!</p>