Sort document based on a field value

Elastic Stack Elasticsearch
1

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.

2

Hi @mohammedsajidkhaleel

I don't know if you use geolocation but if so, you can try to test the _geo_distance sort. Another option would be to use function score query with decay functions.

3

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": [ "*" ] } }

4

where is param origin?

5

As creationdatetime is date field it will take the current time as origin

6

{ "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" } ] }

7

This isn't seems a date format.

8

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" } ]

9

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.

10

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.