Regarding nested query

[pamit]

Hi,

I have a 'Tweet' model which belongs to a 'Profile' model. Tweet(:title, :text, :profile_id) Profile(:name, :visits)

I need to search for tweets which has a profile with specific name such as 'xxx' The following is my code which does not work:

mapping do indexes :id, index: :not_analyzed indexes :profile_id, index: :not_analyzed indexes :title, analyzer: 'snowball', boost: 100 indexes :text, analyzer: 'snowball' indexes :created_at, type: 'date', index: :not_analyzed indexes :profile do indexes :id, index: :not_analyzed indexes :name, analyzer: 'snowball' end
end

def self.search (q, page) tire.search(load: true, :per_page => 10, :page => page) do query { string (q + "*"), default_operator: "AND" } if q.present? filter :range, created_at: {lte: Time.zone.now} # filter :terms, :profile_id => [1,2,3], :execution => 'or' ### this works! # filter :terms, 'profile.name' => ['Payam','Navid'] ### this does not work! end end

Please help me. Thank you in advance.