# Sort document based on a field value **URL:** \ **Category:** Elasticsearch\ **Created:** [April 16, 2023, 9:04am UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084 "2023-04-16T09:04:33Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![mohammedsajidkhaleel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedsajidkhaleel/32/109402_2.png) [@mohammedsajidkhaleel](https://discuss.elastic.co/u/mohammedsajidkhaleel)\ **Post date:** [April 16, 2023, 9:04am UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/1 "2023-04-16T09:04:33Z")
Hi, Am having a real estate ads and I would like sort the document based on the users current city. All ads based on the current user city should be on top and other cities ads should be after this. What is the option to sort the document. ---
**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\ **Post date:** [April 16, 2023, 3:56pm UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/2 "2023-04-16T15:56:20Z")
Hi @mohammedsajidkhaleel I don't know if you use geolocation but if so, you can try to test the [\_geo\_distance sort](https://www.elastic.co/guide/en/elasticsearch/reference/current/sort-search-results.html#geo-sorting). Another option would be to use function score query with [decay functions.](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-function-score-query.html#function-decay) ---
**Author:** ![mohammedsajidkhaleel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedsajidkhaleel/32/109402_2.png) [@mohammedsajidkhaleel](https://discuss.elastic.co/u/mohammedsajidkhaleel)\ **Post date:** [April 17, 2023, 10:42am UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/3 "2023-04-17T10:42:57Z")
I tried with filter in query to exclude unwanted documents and applied function to boost score. But always it is giving score as 0. Am trying to show all ads for a particular location and then order by the ad creation date. `GET listing-addresses-v1/_search { "from": 0, "query": { "function_score": { "query": { "bool": { "filter": [{ "term": { "isPublished": { "value": true } } }, { "term": { "showDocument": { "value": true } } }] } }, "functions": [{ "filter": { "term": { "cityId.keyword": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8" } }, "weight": 2 }, { "gauss": { "creationDateTime": { "scale": "1d", "offset": "1d", "decay": 0.5 } } }] } }, "size": 10, "_source": { "includes": ["*"] } }` ---
**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\ **Post date:** [April 17, 2023, 12:17pm UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/4 "2023-04-17T12:17:16Z")
> [@mohammedsajidkhaleel](#): > > { "gauss": { "creationDateTime": { "scale": "1d", "offset": "1d", "decay": 0.5 } } } ] } } where is param origin? ---
**Author:** ![mohammedsajidkhaleel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedsajidkhaleel/32/109402_2.png) [@mohammedsajidkhaleel](https://discuss.elastic.co/u/mohammedsajidkhaleel)\ **Post date:** [April 17, 2023, 12:31pm UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/5 "2023-04-17T12:31:24Z")
As creationdatetime is date field it will take the current time as origin ---
**Author:** ![mohammedsajidkhaleel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedsajidkhaleel/32/109402_2.png) [@mohammedsajidkhaleel](https://discuss.elastic.co/u/mohammedsajidkhaleel)\ **Post date:** [April 18, 2023, 8:06am UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/6 "2023-04-18T08:06:02Z")
`{ "Sheet1": [{ "Id": "28c8c95f-7646-42b3-b7b3-0632e4e2b77b", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 870000, "CreationDateTime": 44727.81170042824, "NumberBedrooms": 37, "NumberBathrooms": 4, "IsPublished": "False", "ShowDocument": "True" }, { "Id": "2a0912a7-0dce-42b5-8569-9deea21ff344", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 450000, "CreationDateTime": 44782.63969337963, "NumberBedrooms": 4, "NumberBathrooms": 3, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "01abbc6e-1aec-480e-a8b2-73c1c3c7ce76", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 870000, "CreationDateTime": 44727.80412108796, "NumberBedrooms": 4, "NumberBathrooms": 4, "IsPublished": "False", "ShowDocument": "True" }, { "Id": "2e9b749f-ff75-4d07-845c-1d21dbe13ded", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 840000, "CreationDateTime": 44782.52645868056, "NumberBedrooms": 6, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "333af25f-cc08-4b18-8b6c-4ece5fb91658", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 1700000, "CreationDateTime": 44763.69855013889, "NumberBedrooms": 9, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "2e0473b1-165e-4f82-9122-e1262462ce00", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 870000, "CreationDateTime": 44727.83368747685, "NumberBedrooms": 4, "NumberBathrooms": 4, "IsPublished": "False", "ShowDocument": "True" }, { "Id": "35dc22be-7070-4f7c-8f4a-f8ab8899a44f", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 450000, "CreationDateTime": 44782.63956829861, "NumberBedrooms": 4, "NumberBathrooms": 3, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "13f132ce-7808-4267-9d88-4b6e00d84f1a", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 450000, "CreationDateTime": 44782.63994765046, "NumberBedrooms": 4, "NumberBathrooms": 3, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "36245ab0-9bfa-4aff-b1d5-3da0ee64205e", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 450000, "CreationDateTime": 44782.64209300926, "NumberBedrooms": 4, "NumberBathrooms": 3, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "370d8456-1e28-496e-8f55-302343d91ac6", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 1700000, "CreationDateTime": 44763.69692417824, "NumberBedrooms": 9, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "293c44ec-4335-45ac-9d33-1f29e21241c7", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 1500000, "CreationDateTime": 44727.89617361111, "NumberBedrooms": 9, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "46e34ae5-4f4d-41dd-9aaf-7093836ef80c", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 450000, "CreationDateTime": 44782.64389947917, "NumberBedrooms": 4, "NumberBathrooms": 3, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "43ed7f45-967f-4dc3-8c06-efa6b97c5623", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 850000, "CreationDateTime": 44782.52399957176, "NumberBedrooms": 6, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "3e9f7804-92f6-409d-bb32-e1b7320de4f8", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 870000, "CreationDateTime": 44727.801748935184, "NumberBedrooms": 4, "NumberBathrooms": 4, "IsPublished": "False", "ShowDocument": "True" }, { "Id": "4c06c57d-b29d-428d-a16d-51770413b1f3", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 760000, "CreationDateTime": 44776.65592732639, "NumberBedrooms": 6, "NumberBathrooms": -4, "IsPublished": "False", "ShowDocument": "True" }, { "Id": "19264a02-106d-44fd-b533-39b70c60732c", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 825000, "CreationDateTime": 44782.536740474534, "NumberBedrooms": 6, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "04d97d7e-e25b-4e1e-8dfd-2c25a09ade14", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 870000, "CreationDateTime": 44727.83626978009, "NumberBedrooms": 4, "NumberBathrooms": 4, "IsPublished": "False", "ShowDocument": "True" }, { "Id": "3da68b89-7da1-43ec-bdc3-9cfa141bdbcc", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 840000, "CreationDateTime": 44782.52752908565, "NumberBedrooms": 6, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "00c8aace-24ef-4833-b39d-c03d09aecffd", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 450000, "CreationDateTime": 44782.64227478009, "NumberBedrooms": 4, "NumberBathrooms": 3, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "48f442b5-32a3-431e-ae78-900e825b868f", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 760000, "CreationDateTime": 44776.664605625, "NumberBedrooms": 6, "NumberBathrooms": -4, "IsPublished": "False", "ShowDocument": "True" }, { "Id": "45338384-fd9e-4ec7-a6dc-31b3155c2660", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 825000, "CreationDateTime": 44782.53535278935, "NumberBedrooms": 6, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "40b9bd6e-92d8-40e5-93f6-b0a2653f6bab", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 850000, "CreationDateTime": 44782.52303596065, "NumberBedrooms": 6, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "295f096c-aa1a-49a0-b319-aa687008c109", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 825000, "CreationDateTime": 44782.534902210646, "NumberBedrooms": 6, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "5b5d28f4-207b-45f1-8597-09110b53c0e6", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 1700000, "CreationDateTime": 44749.45155060185, "NumberBedrooms": 9, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }, { "Id": "59a05e33-ce5d-4cd1-bf67-5f26df55e1d2", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": 1300000, "CreationDateTime": 44776.71055081019, "NumberBedrooms": 8, "NumberBathrooms": 5, "IsPublished": "True", "ShowDocument": "True" }] }` ---
**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\ **Post date:** [April 18, 2023, 12:34pm UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/7 "2023-04-18T12:34:17Z")
> [@mohammedsajidkhaleel](#): > > "CreationDateTime": 44782.63956829861 This isn't seems a date format. ---
**Author:** ![mohammedsajidkhaleel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedsajidkhaleel/32/109402_2.png) [@mohammedsajidkhaleel](https://discuss.elastic.co/u/mohammedsajidkhaleel)\ **Post date:** [April 18, 2023, 1:20pm UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/8 "2023-04-18T13:20:49Z")
Ohh sorry for that. exporting caused issue. ` { "Id": "28c8c95f-7646-42b3-b7b3-0632e4e2b77b", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "870000", "CreationDateTime": "2022-06-15 16:27:58.917995+00", "NumberBedrooms": "37", "NumberBathrooms": "4", "IsPublished": "FALSE", "ShowDocument": "TRUE" }, { "Id": "2a0912a7-0dce-42b5-8569-9deea21ff344", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "450000", "CreationDateTime": "2022-08-09 12:20:17.50803+00", "NumberBedrooms": "4", "NumberBathrooms": "3", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "01abbc6e-1aec-480e-a8b2-73c1c3c7ce76", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "870000", "CreationDateTime": "2022-06-15 16:17:04.062087+00", "NumberBedrooms": "4", "NumberBathrooms": "4", "IsPublished": "FALSE", "ShowDocument": "TRUE" }, { "Id": "2e9b749f-ff75-4d07-845c-1d21dbe13ded", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "840000", "CreationDateTime": "2022-08-09 09:37:14.030823+00", "NumberBedrooms": "6", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "333af25f-cc08-4b18-8b6c-4ece5fb91658", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "1700000", "CreationDateTime": "2022-07-21 13:45:02.732723+00", "NumberBedrooms": "9", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "2e0473b1-165e-4f82-9122-e1262462ce00", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "870000", "CreationDateTime": "2022-06-15 16:59:38.598762+00", "NumberBedrooms": "4", "NumberBathrooms": "4", "IsPublished": "FALSE", "ShowDocument": "TRUE" }, { "Id": "35dc22be-7070-4f7c-8f4a-f8ab8899a44f", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "450000", "CreationDateTime": "2022-08-09 12:20:06.701727+00", "NumberBedrooms": "4", "NumberBathrooms": "3", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "13f132ce-7808-4267-9d88-4b6e00d84f1a", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "450000", "CreationDateTime": "2022-08-09 12:20:39.477062+00", "NumberBedrooms": "4", "NumberBathrooms": "3", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "36245ab0-9bfa-4aff-b1d5-3da0ee64205e", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "450000", "CreationDateTime": "2022-08-09 12:23:44.836789+00", "NumberBedrooms": "4", "NumberBathrooms": "3", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "370d8456-1e28-496e-8f55-302343d91ac6", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "1700000", "CreationDateTime": "2022-07-21 13:42:42.249304+00", "NumberBedrooms": "9", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "293c44ec-4335-45ac-9d33-1f29e21241c7", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "1500000", "CreationDateTime": "2022-06-15 18:29:37.400371+00", "NumberBedrooms": "9", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "46e34ae5-4f4d-41dd-9aaf-7093836ef80c", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "450000", "CreationDateTime": "2022-08-09 12:26:20.915041+00", "NumberBedrooms": "4", "NumberBathrooms": "3", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "43ed7f45-967f-4dc3-8c06-efa6b97c5623", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "850000", "CreationDateTime": "2022-08-09 09:33:41.563834+00", "NumberBedrooms": "6", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "3e9f7804-92f6-409d-bb32-e1b7320de4f8", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "870000", "CreationDateTime": "2022-06-15 16:13:39.108053+00", "NumberBedrooms": "4", "NumberBathrooms": "4", "IsPublished": "FALSE", "ShowDocument": "TRUE" }, { "Id": "4c06c57d-b29d-428d-a16d-51770413b1f3", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "760000", "CreationDateTime": "2022-08-03 12:43:40.121978+00", "NumberBedrooms": "6", "NumberBathrooms": "-4", "IsPublished": "FALSE", "ShowDocument": "TRUE" }, { "Id": "19264a02-106d-44fd-b533-39b70c60732c", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "825000", "CreationDateTime": "2022-08-09 09:52:02.377807+00", "NumberBedrooms": "6", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "04d97d7e-e25b-4e1e-8dfd-2c25a09ade14", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "870000", "CreationDateTime": "2022-06-15 17:03:21.709528+00", "NumberBedrooms": "4", "NumberBathrooms": "4", "IsPublished": "FALSE", "ShowDocument": "TRUE" }, { "Id": "3da68b89-7da1-43ec-bdc3-9cfa141bdbcc", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "840000", "CreationDateTime": "2022-08-09 09:38:46.513609+00", "NumberBedrooms": "6", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "00c8aace-24ef-4833-b39d-c03d09aecffd", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "450000", "CreationDateTime": "2022-08-09 12:24:00.541641+00", "NumberBedrooms": "4", "NumberBathrooms": "3", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "48f442b5-32a3-431e-ae78-900e825b868f", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "760000", "CreationDateTime": "2022-08-03 12:56:09.926238+00", "NumberBedrooms": "6", "NumberBathrooms": "-4", "IsPublished": "FALSE", "ShowDocument": "TRUE" }, { "Id": "45338384-fd9e-4ec7-a6dc-31b3155c2660", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "825000", "CreationDateTime": "2022-08-09 09:50:02.481446+00", "NumberBedrooms": "6", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "40b9bd6e-92d8-40e5-93f6-b0a2653f6bab", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "850000", "CreationDateTime": "2022-08-09 09:32:18.307699+00", "NumberBedrooms": "6", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "295f096c-aa1a-49a0-b319-aa687008c109", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "825000", "CreationDateTime": "2022-08-09 09:49:23.551682+00", "NumberBedrooms": "6", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "5b5d28f4-207b-45f1-8597-09110b53c0e6", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "1700000", "CreationDateTime": "2022-07-07 07:49:21.972411+00", "NumberBedrooms": "9", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" }, { "Id": "59a05e33-ce5d-4cd1-bf67-5f26df55e1d2", "SellerId": "5ba07d2a-fade-4aac-ba8a-ceb98e5a231d", "City": "Jeddah", "CityId": "de9133ff-ae93-48fa-bbf3-ff83fe21a9c8", "Price": "1300000", "CreationDateTime": "2022-08-03 14:02:19.590399+00", "NumberBedrooms": "8", "NumberBathrooms": "5", "IsPublished": "TRUE", "ShowDocument": "TRUE" } ]` ---
**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\ **Post date:** [April 18, 2023, 2:41pm UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/9 "2023-04-18T14:41:19Z")
You are receiving score 0 because the origin is date now. Try set origin because the CreationDateTime has date before 2023. > Required for geo and numeric field. For date fields the default is `now` . Date math (for example `now-1h` ) is supported for origin. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 16, 2023, 2:41pm UTC](https://discuss.elastic.co/t/sort-document-based-on-a-field-value/330084/10 "2023-05-16T14:41:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.