# KQL : query\_string doesn't work

**URL:** <https://discuss.elastic.co/t/kql-query-string-doesnt-work/274451>\
**Category:** Elasticsearch\
**Created:** [May 31, 2021, 5:53am UTC](https://discuss.elastic.co/t/kql-query-string-doesnt-work/274451 "2021-05-31T05:53:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![lls](https://avatars.discourse-cdn.com/v4/letter/l/eb8c5e/32.png) [@lls](https://discuss.elastic.co/u/lls)\
**Post date:** [May 31, 2021, 5:53am UTC](https://discuss.elastic.co/t/kql-query-string-doesnt-work/274451/1 "2021-05-31T05:53:49Z")

</div>

Hi there:  
Interestingly, I'm not sure why the below "query\_string" doesn't returns any hits but it returns hits on 'Discovery UI's Filters section. Please advise, thanks

"sql\_string" - This doesn't return any hits

```auto
GET system-metric*/_search
{
  "query" : {
     "query_string": {
          "query: "type:metricsets AND system.filesystem.used.pct: >0.8"
     }
  }
}

```

Discovery UI - Filters section where you can enter KQL - This returned hits

```auto
 system.filesystem.used.pct >0.8

```

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [May 31, 2021, 7:23am UTC](https://discuss.elastic.co/t/kql-query-string-doesnt-work/274451/2 "2021-05-31T07:23:11Z")

</div>

KQL only works within Kibana, the `query_string` query is a different beast. Specifying ranges with the query string query is explained here: [Query string query | Elasticsearch Guide [7.13] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/7.13/query-dsl-query-string-query.html#_ranges)

Hope that helps!

---

<div class="post-metadata">

**Author:** ![lls](https://avatars.discourse-cdn.com/v4/letter/l/eb8c5e/32.png) [@lls](https://discuss.elastic.co/u/lls)\
**Post date:** [May 31, 2021, 9:42pm UTC](https://discuss.elastic.co/t/kql-query-string-doesnt-work/274451/3 "2021-05-31T21:42:07Z")

</div>

Yay..it's working with ranges. I'm so happy now, thanks for your helps, Alex.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 28, 2021, 9:42pm UTC](https://discuss.elastic.co/t/kql-query-string-doesnt-work/274451/4 "2021-06-28T21:42:28Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.