# How to query empty values of number type and date type fields

**URL:** <https://discuss.elastic.co/t/how-to-query-empty-values-of-number-type-and-date-type-fields/108938>\
**Category:** Elasticsearch\
**Created:** [November 23, 2017, 7:43pm UTC](https://discuss.elastic.co/t/how-to-query-empty-values-of-number-type-and-date-type-fields/108938 "2017-11-23T19:43:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kabali12345](https://avatars.discourse-cdn.com/v4/letter/k/6a8cbe/32.png) [@kabali12345](https://discuss.elastic.co/u/kabali12345)\
**Post date:** [November 23, 2017, 7:43pm UTC](https://discuss.elastic.co/t/how-to-query-empty-values-of-number-type-and-date-type-fields/108938/1 "2017-11-23T19:43:20Z")

</div>

Hi all.....  
we have a index having number type field which holds some empty values as well  
but when we try to filter empty(null) event from kibana discovery we are getting error

```auto
Discover: [parsing_exception] [match] unknown token [VALUE_NULL] after [query], with { line=1 & col=177 }
Error: [parsing_exception] [match] unknown token [VALUE_NULL] after [query], with { line=1 & col=177 }
   at respond (http://192.168.1.62:5601/bundles/kibana.bundle.js?v=15063:12:2730)
   at checkRespForFailure (http://192.168.1.62:5601/bundles/kibana.bundle.js?v=15063:12:1959)
   at http://192.168.1.62:5601/bundles/kibana.bundle.js?v=15063:1:9200
   at processQueue (http://192.168.1.62:5601/bundles/commons.bundle.js?v=15063:38:23621)
   at http://192.168.1.62:5601/bundles/commons.bundle.js?v=15063:38:23888
   at Scope.$eval (http://192.168.1.62:5601/bundles/commons.bundle.js?v=15063:39:4619)
   at Scope.$digest (http://192.168.1.62:5601/bundles/commons.bundle.js?v=15063:39:2359)
   at Scope.$apply (http://192.168.1.62:5601/bundles/commons.bundle.js?v=15063:39:5037)
   at done (http://192.168.1.62:5601/bundles/commons.bundle.js?v=15063:37:25027)
   at completeRequest (http://192.168.1.62:5601/bundles/commons.bundle.js?v=15063:37:28702)

```

here is index details

```auto
PUT number
{
  "mappings": {
    "my_type": {
      "properties": {
        "ExpireTime": {
          "type": "long"
        }
      }
    }
  }
}
PUT number/my_type/1
{
  "ExpireTime": 1
}
PUT number/my_type/2
{
  "ExpireTime": 1.1
}
PUT number/my_type/3
{
  "ExpireTime": null
}

```

How can i over come with this problem?

Thank You

---

<div class="post-metadata">

**Author:** ![luiz.santos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luiz.santos/32/24664_2.png) [@luiz.santos](https://discuss.elastic.co/u/luiz.santos)\
**Post date:** [December 1, 2017, 1:10pm UTC](https://discuss.elastic.co/t/how-to-query-empty-values-of-number-type-and-date-type-fields/108938/2 "2017-12-01T13:10:54Z")

</div>

Hi kabali12345,

What version of kibana are you using? And what is the query you are using in the discovery searchbox?

Can you try _exists_:ExpireTime and see if it works?

Cheers,  
LG

---

<div class="post-metadata">

**Author:** ![kabali12345](https://avatars.discourse-cdn.com/v4/letter/k/6a8cbe/32.png) [@kabali12345](https://discuss.elastic.co/u/kabali12345)\
**Post date:** [December 11, 2017, 3:54pm UTC](https://discuss.elastic.co/t/how-to-query-empty-values-of-number-type-and-date-type-fields/108938/3 "2017-12-11T15:54:25Z")

</div>

Yes it's worked  
Thank you @luiz.santos

---

<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:** [January 8, 2018, 4:01pm UTC](https://discuss.elastic.co/t/how-to-query-empty-values-of-number-type-and-date-type-fields/108938/4 "2018-01-08T16:01:50Z")

</div>

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