How to build dynamic query on Elasticsearch, which will execute on Node.js

Question

When I tried to create query like

var my_query = new Object("[{ \"match\": { \"techskills.programming\":"+ programming+" } }]");

var deferred = Q.defer();
client.search({
    "index": _index,
    "type": _type,
    "body": {
        "query": {
            "bool": {
                "must": my_query
            }
        }
    }
},function (error,resp) {
    console.log("Found error is ::::: "+error + " resp::: "+JSON.stringify(resp));
    if(error) deferred.reject(error);
    deferred.resolve(resp);
});
return deferred.promise;

I am getting the following error:

[query_parsing_exception] [bool] query does not support [must]

amit shukla · Accepted Answer · 2016-04-19 13:31:46Z

3

I have solved this by creating complete body tag as dynamic query string and passed this variable to the elasticsearch query. ex: var my_query = "{\"query\": {\"bool\":{\"must\": [{ \"match\": { \"techskills.programming\":\"" + programming + "\"} }]}}}"

client.search({ "index": _index, "type": _type, body:my_query },function (error,resp) { console.log("Found error is ::::: "+error + " resp::: "+JSON.stringify(resp)); if(error) deferred.reject(error); deferred.resolve(resp); });

answered Apr 19, 2016 at 13:31

amit shukla

313 bronze badges

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

1 Comment

GuiPab Over a year ago

Thank you so much, i spend one whole afternoon trying to achieve that lol

Collectives™ on Stack Overflow

How to build dynamic query on Elasticsearch, which will execute on Node.js

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related