elasticsearch unable to query path in ruby

Question

I have an elasticsearch index 'events' - within that index there's a type 'event'.

event objects have a 'venue' which has various properties, including a 'name' - so the simplified structure is:

event {
  venue {
    name: "foo"
  }
}

Now, i'm using elasticsearch-rails - everything works fine for listing the events, searching etc using the query dsl - but what if i want to list all the events at a venue with a particular name?

I'm assuming something like this should be possible:

Event.search "{ 'query': { 'match': { 'venue.name': '#{params[:v]}' }}}

but i get the following error:

Elasticsearch::Transport::Transport::Errors::BadRequest

followed by a substantial stack trace which contains a lot of this sort of thing:

Was expecting one of:\n    \"]\" ...\n    \"}\" ...\n    ];

ParseExceptions suggesting malformed json - but i'm not sure why.

The simple search

Event.search '{"query" : { "match_all" : {} }}'

works fine, so i'm guessing it's just the structure of the query that's wrong.

I've tried switching single/double quotes around, tried following more closely the example on this page:

https://www.elastic.co/guide/en/elasticsearch/guide/current/denormalization.html

all to no avail, wondered if anyone else had encountered this situation and could suggest how to work this in ruby.

Answer 1

The Json you are trying to pass to the search function is not a valid Json. You can try passing a hash instead of Json to the search function. Try the following:

query_hash = {query: {match: {'venue.name' => params[:v] }}}
Event.search query_hash