Associated model properties in where clause? about searchkick HOT 5 CLOSED

There's no way to do this right now. The best way (in your simple example) would be to change search data to:

def search_data
  as_json(only: [:title, :created_at]).merge(user_id: user.id)
end

The ability to query nested documents would be nice as long as it's simple. I'm going to remove the nested example from the readme for now.

from searchkick.

Right, I thought that the merging could do it, but I'd be doing it for a number of associated model properties. It might be okay, so I'll try that out. Handling associations would be a great addition later. Thanks.

from searchkick.

Ah, and I forgot the other issue, which is that I'm dealing with a set of associated objects, which gets trickier of course. For example, if I have Items and each Item has many Users, and I need to be able to search for all of the Items with name "Foo" that are associated with a specific user. It's not well-suited for the merge solution. Thanks again.

from searchkick.

While you can't search nested attributes, you can search arrays.

class Item
  def search_data
    {user_ids: users.pluck(:id)}
  end
end

And

Item.search "Foo", where: {user_ids: 1}

Hopefully that helps with your last comment.

from searchkick.

Created a new issue for nested queries #145

from searchkick.