Hello
I'm having problems with sorting. I want to get the latest data (with the biggest date_created). So I curl like this: curl -vsX GET myelastic.com/notifications/notification/_search -d '{ "query": { "bool": { "must": [ { "term": { "type": "config_withdraw" } } ], "must_not": [], "should": [] } }, "sort": [ { "date_created": "desc" } ], "size": 1 }'|python -mjson.tool RESULT: { "_shards": { "failed": 0, "successful": 10, "total": 10 }, "hits": { "hits": [ { "_id": "a3Rks7DNTYWGDRZzVg5g8Q", "_index": "notifications", "_score": null, "_source": { "date_created": "2024-02-01T13:49:52.454-04:00", "expiration_date": "2024-02-01T13:49:52.452-04:00", "level": null, "model": { "user_id": 80843387 }, "reference_id": null, "status": "new", "type": "config_withdraw", "user_id": "80843387" }, "_type": "notification", "sort": [ 1706809792454 ] } ], "max_score": null, "total": 10533937 }, "timed_out": false, "took": 163 } But this is not the latest data becouse in another search I get a bigger date_created: curl -vsX GET myelastic.com/notifications/notification/_search -d '{ "query": { "bool": { "must": [ { "term": { "user_id": "153423413" } } ], "must_not": [], "should": [] } }, "sort": [ { "date_created": "desc" } ], "size": 1 }'|python -mjson.tool RESULT: { "_shards": { "failed": 0, "successful": 10, "total": 10 }, "hits": { "hits": [ { "_id": "PfWSkIDxSk2ou62Yiqbudw", "_index": "notifications", "_score": null, "_source": { "date_created": "2014-02-03T13:48:11.524-04:00", "expiration_date": "2024-02-01T13:48:11.524-04:00", "level": null, "model": { "user_id": 153423413 }, "reference_id": null, "status": "new", "type": "config_withdraw", "user_id": "153423413" }, "_type": "notification", "sort": [ 1391449691524 ] } ], "max_score": null, "total": 2 }, "timed_out": false, "took": 36 } So I don't know what is the problem, maybe you can give me some pointer. BTW this is the mapping of the type curl -vsX GET myelastic.com/notifications/notification/_mapping RESULT: { "notification": { "properties": { "date_created": { "format": "dateOptionalTime", "type": "date" }, "expiration_date": { "format": "dateOptionalTime", "type": "date" }, "id": { "type": "string" }, "model": { "properties": { "bank": { "type": "string" }, "new_status": { "type": "string" }, "status": { "type": "string" }, "user_id": { "type": "long" } } }, "reference_id": { "type": "long" }, "status": { "type": "string" }, "type": { "type": "string" }, "user_id": { "type": "string" } } } } -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/30763a38-3b05-4c22-a910-f24b0f8e35d4%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.