How to sort in elasticsearch?

Question

elasticsearch

I have a Users table, in elastic I make a selection on it.
I have a field in each object that contains an array of dates:

{
  _id: <user id>,
  dates: [..., {dataFrom: <dateFrom>, dateTo: <dateTo>}]
}

You need to sort by the dateFrom key of the last object in the dates array.
Help :)

Answer 1

Somehow your data is wrong for this. It would be better to break each entry into separate documents: id, dateFrom, dateTo. And the problem would be solved automatically.
Well, as an option, do sorting outside the elastic after the selection.
And another option is to duplicate entries in a separate index for separate documents, as I wrote above.