I am trying to figure out if I should use the datatype nested, flattened och object when using an index template to better map my index.
I've got some large documents with some arrays and several objects within them. I have tried nested and the drawback is that the searching is creating problems, but I wonder if that is manageable in some way by assigning keywords in a better way? Before I try anything I would like some input.
I want the documents to look as it does in the db
and not like it is indexed by elastic which is grouping all object values like so
Aggregations must be possible also to be able to make comparisons with piecharts and such which has been the problem with nested, but maybe I am doing it wrong?