title: How to add multiple fields in filter (term) query to simulate OR in ElasticSearch
body: <p>Hello everyone  not sure if the title is clear enough so I will jump straight ahead to the example that I have.</p>
  <p>I have some cars inside my index, and all of them have make and model. I am doing a count query and I want to count all combinations. Let's take a look at the following query:</p>
  <pre><code>{
      &quot;query&quot;: {
          &quot;bool&quot;: {
              &quot;filter&quot;: [
                  {
                      &quot;terms&quot;: {
                          &quot;model&quot;: [
                              &quot;a5&quot;,
                              &quot;a4&quot;
                          ]
                      }
                  },
                  {
                      &quot;terms&quot;: {
                          &quot;make&quot;: [
                              &quot;audi&quot;,
                              &quot;bmw&quot;
                          ]
                      }
                  }
              ]
          }
      }
  }
  </code></pre>
  <p>This works but not exactly what I want. There is no relation here between makes and models, but I want to have a relation because <code>a5</code> and <code>a4</code> are only related to <code>audi</code>, not <code>bmw</code>, and thats the reason why I am getting the wrong results. It sould count all <code>a4</code> and <code>a5</code> audis, and all bmws, doesn't matter which model they are, but instead of that I am getting count only for audis, because there is no <code>a4</code> and <code>a5</code> in bmws.</p>
  <p>Ideally, I would use something like this:</p>
  <pre><code>&quot;filter&quot;: [
      {
          &quot;terms&quot;: {
              &quot;model&quot;: [
                  &quot;a5&quot;,
                  &quot;a4&quot;
              ],
              &quot;make&quot;: [&quot;audi&quot;]
          }
      },
      {
          &quot;terms&quot;: {
              &quot;make&quot;: [
                  &quot;bmw&quot;
              ]
          }
      }
  ]
  </code></pre>
  <p>but this is not possible due to es error: <code>[terms] query does not support multiple fields</code>.</p>
  <p>I would be grateful if some of you have the workaround for the issue that I have. Thanks in advance!</p>