hi. im using Kibana 6.4.1.
i want to filter '_source' field and sorted by '_source.date' field in 'Discover' tab of Kibana
because, variable fields can be exist in each document.
this mean, each documents in one index can have variable fields.
i know that i can select multiple field (in Discover tab),
and set priority(in Advanced Settings),
and can select Default fields(in Advanced Settings).
but as i said, each docs have variable fields each other.
so, i don't care about index mapping and i cant select designated field.
i must show all of fields.
if field as 'a', 'b', 'c', 'date' incoming once in Aindex, and field as 'd', 'e', 'f', 'date' once in Aindex,
Aindex will have 2 docs.
and i want to show these 2 docs with _source.
Aindex
doc1 : a, b, c, date
doc2 : d, e, f, date
and i want to sorting these docs by 'date' field.
(date field is exist in all of docuements as 'date' type mapped.)
can i handle this? or any idea?
i tried this query in window filter like this.
as text,
{
"query": {
"match_all": {}
},
"sort": [
{
"date": {
"order": "desc"
}
}
]
}
but this doesn't working.
i can show all of fields with '_source' but not sorted by date.
in this reference
(https://www.elastic.co/guide/en/kibana/6.4/field-filter.html)
there is image that exist 'Time' and '_source' as table header.
but when i selected 'date' field('_source.date'), '_source ' field was disappeared.
and i saw this topic.
(Sorting by keyword in Kibana Discover)
there is 'Time' and '_source' header appeared again
but my discover doesn't include that header.
and i guess that above topic using '@timestamp' field.
but i don't want to use this field.
the reason is same with above topic's owner.
i want to use '_source.date' field as date field