Data table with nested Fields

Elastic Stack Kibana
1

I have this field in my documents

"DAList" : [
{
"DA_Change" : 50195,
"DA_ID" : 8,
"DA_Before" : 325468,
"DA_After" : 275273,
"DA_ExpDate" : "2018-12-08T22:00:00.000Z"
},
{
"DA_Change" : 0,
"DA_ID" : 23,
"DA_Before" : 2660000,
"DA_After" : 2660000,
"DA_ExpDate" : "2018-12-08T22:00:00.000Z"
}
I want to view these data on the data table without mixing up values. Like I have number ID field in the same document and it mixes the nested fields data

elastic%20table
elastic table.png1920×1080 201 KB

I have 14 documents for testing and each DAList has 2 objects so I should have only 28 rows with no mixed up values

2

Kibana does not yet support nested queries. With a non-nested query you can get results where elements from the nested blocks are mixed. See the documentation for nested datatypes for more details.