Search for exact field in an array of strings in elasticsearch with sorting via latest publication date

Question

This is a follow-up question of exact string search in an array of strings.

There is another thing if the document has a publishing date.

{
   "datePublished":"2020-05-22T15:06:00.000Z",
   "locations":[
      "Landkreis Cloppenburg",
      "Berlin"
   ]
}

and sort them with the latest publication date. Then the result is coming back with the Landkreis Cloppenburg if I have this in the query:

"sort": [
   {
      "doc.datePublished":{
         "order":"desc"
      }
   }
]

GET article/_search { "sort": [ { "doc.datePublished": { "order": "desc" } } ], "query": { "bool": { "must": [ { "match": { "locations": { "query": "Cloppenburg" } } } ] } } } — Jawad
– Jawad, Commented Jun 8, 2020 at 13:31

Amit · Accepted Answer · 2020-06-08 13:43:42Z

1

the correct query should be like below

{
    "sort": [
        {
            "datePublished": {
                "order": "desc"
            }
        }
    ],
    "query": {
        "term": {
            "location": {
                "value": "Cloppenburg"
            }
        }
    }
}

As the previous answer was written by me, I just enhanced and included your date field, so my mapping looks like

{
    "mappings": {
        "properties": {
            "location": {
                "type": "keyword"
            },
            "datePublished" : {
                "type" : "date"
            }
        }
    }
}

answered Jun 8, 2020 at 13:43

Amit

32.5k7 gold badges68 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jawad Over a year ago

you are a rockstar, million thanks :) Please upvote my question :)

Collectives™ on Stack Overflow

Search for exact field in an array of strings in elasticsearch with sorting via latest publication date

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related