asked on April 17, 2019
Hi,
It's possible to use datatype (DATE) with Elasticsearch?
That's what I'm trying to do.
"dataSource": {
"dataSourceType": "elasticsearch",
"host": "http://192.168.0.204:9200",
"index": "pdg",
"mappings": {
"TERM_DT": {
"type": "datetime"
}
}
}
⋅ April 18, 2019
Hello, Mario,
Thank you for your question.
It’s possible to use datatype (DATE) with Elasticsearch without specifying in mapping explicitly.
We kindly advise using the mapping property to modify how the data is represented.
For example:
mapping: {
"@timestamp": {
"format": "dd/MM/yyyy"
}
}
(Please see more about the mapping property here: https://www.flexmonster.com/api/report-object/ )
Our team has prepared a JSFiddle example for illustration.
Please let us know if this works for you and if you have further questions.
Best Regards,
Vera
⋅ April 18, 2019
Thx ! It work's.
Complementing my question, how to make the filter behavior like this example?
https://jsfiddle.net/flexmonster/h4qzupbb/
⋅ April 19, 2019
Hello, Mario,
Thank you for the update.
We are glad to hear that everything works.
We would like to make sure if we understood your question correctly:
You are interested in the range filter?
The range filter is currently available for CSV/JSON only.
For Elasticsearch, we suggest using filtering by members.
Please let us know if you have further questions.
Best Regards,
Vera