I want to search in kibana where the "DUE_DATE" is not having any value. I have tried like below. But it is giving me all the documents with and without date field. I need to get only doc2. Can someone please help me in searching.
query which i have tried: response: "\{\"Id\":\"DUE_DATE\"\,\"value\":\"\"\}"
Here are some examples: 1) if you are using KQL which is the Kibana search box, you can use something like this: not DUE_DATE:* or 2) you can add a filter in Kibana NOT DUE_DATE: "exists" or 3) In Elasticsearch Query DSL ```
GET /_search
{
"query": {
"bool": {
"must_not": {
"exists": {
"field": "DUE_DATE"
}
}
}
}
}
Thanks for the response. The above query is giving me the records where I don't have DUE_DATE attribute instead of giving me DUE_DATE records with empty value.
I have tried something like this in the kibana search bar and it is giving me the records where DUE_DATE is empty like below.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.