Order by timeUpdated, if exists, otherwise timeCreated Order by timeUpdated, if exists, otherwise timeCreated elasticsearch elasticsearch

Order by timeUpdated, if exists, otherwise timeCreated


You need script sorting in this case:

{  "query": {    "match_all": {}  },  "sort": {    "_script": {      "script": "if (doc['timeUpdated'].value != 0) doc['timeUpdated'].value else doc['timeCreated'].value",      "type": "number",      "order": "desc"    }  }}