Table doesn't apply queries properly

[mikapp]

Table doesn't apply queries properly

[jammann]

Also from me: thanks for the excellent work! This bug here (which I think is a dupe of #4) disturbs me. I think I found the reason. It's happening (for me) always when I have both QUERY and FILTER restrictions - which is almost always the case

Panels work because there the QUERY parts from Kibana is applied with a SHOULD in the ES query, while the FILTER parts are applied as filtered aggregations to the aggs themselves

In the table however the part from Kibana FILTER and QUERY are applied within one big bool filter. And per the documentation https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html a SHOULD term in such a combination is only used for scoring, but not really for filtering

I will try to come up with a pull request

[mikapp]

Here are JSONs from inspect field for table panel in both original Kibana 3 and this fork so it might help to see why it behaves differently:

Original Kibana with ES 1.7

"query": {
    "filtered": {
      "query": {
        "bool": {
          "should": [
            {
              "query_string": {
                "query": "*"
              }
            }
          ]
        }
      },
      "filter": {
        "bool": {
          "must": [
            {
              "range": {
                "@timestamp": {
                  "from": 1509732179320,
                  "to": 1509735779320
                }
              }
            }
          ]
        }
      }
    }
  },
  

Custom Kibana3 with ES 5.6

"query": {
    "bool": {
      "filter": [
        {
          "range": {
            "@timestamp": {
              "from": 1509715711095,
              "to": 1509737311095
            }
          }
        },
        {
          "range": {
            "@timestamp": {
              "from": 1509720759162,
              "to": 1509721934842
            }
          }
        }
      ],
      "should": [
        {
          "query_string": {
            "query": "*"
          }
        }
      ]
    }
  },

[mikapp]

@jammann I forked your branch with fixes and it works fine for me. Table now only shows data from query as expected. Thanks for addressing it!