Date with long value not working

Elastic Stack Elasticsearch
1

I have below mapping
{
"indexTest": {
"mappings": {
"indexTest_type": {
"properties": {
"date22": {
"type": "dateColumn",
"format": "yyyy-MM-dd||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS'Z'||HH:mm:ss||HH:mm:ss.SSS||epoch_millis"
}
}
}
}
}
}

indexed value

"_source": {
"dateColumn": "2017-09-01"
}

I am trying to search based on long value of date i am not getting the response . Please find search query below

GET indexTest/_search
{
"query": {
"match": {
"dateColumn": {
"query": "1504204200000"
}
}
}
}

same is working for dateTime value

2

can you please provide a fully fledged example for reproduction, which includes index creation, mapping creation, document indexing? You mentioned a dateTime value, but your _source does not include it.

Please take some time to come up with something that is reproducible for others, otherwise it is super hard to help.

Also, as this forum supports markdown, please use it to properly format code snippets - this makes it infinitely more readable, which increases your chances of someone looking at your problem.

Thanks a lot!

3

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