Access field document in query elasticsearch

Question

For example suppose we have this mapping :

{
    "location":{
        "dynamic":"false",
        "properties":{
            "locality":{"type":"text"},
            "country":{"type":"text"},
            "postalCode":{"type":"text"},
            "coordinates":{"type":"geo_point"},
            "radius":{"type":"double"}
        }
    }
}

And this is my query :

GET index_name/location/_search
{
    "query": {
        "bool": {
            "filter": {
                "geo_distance": {
                    "coordinates": [
                        2.352222, 
                        48.999
                    ],
                    "distance": $radius <--- *(here I want to access the
                                               value of radius in document)*
                 }
            }
        }
    }
}

Is there a mean to access a field document value in an Elasticsearch query ?

Is it feasible using Script Query ? doc here

The docs you linked do just that, so I don't see why it wouldn't be feasible.. — ryanlutgen
– ryanlutgen, Commented Feb 9, 2018 at 17:04

Omarkad · Accepted Answer · 2018-02-09 18:16:59Z

1

Yes actually the Script Query does the trick :

GET index_name/location/_search
{
    "query": {
        "bool": {
            "must": [
                {
                    "script": {
                        "script": {
                            "inline": "doc['coordinates'].planeDistance(48.856614 , 2.37959999) <= doc['radius'].value",
                            "lang": "painless"
                        }
                    }
                 }
            ]
        }
    }
}

thanks

answered Feb 9, 2018 at 18:16

Omarkad

2895 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Access field document in query elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related