I am having an issue with filtering on an associations attribute. When I run
a search I want all the associations attributes to match to return a result.
class Publication < ActiveRecord::Base
belongs_to :imprint
has_many :products
has_many :subscriptions
belongs_to :cover_image
belongs_to :edition
define_index do
indexes [edition.title_prefix,
edition.title,
edition.subtitle], :as => :title, :sortable => true
indexes [edition.work.authorships.authorizable.profile.given_names,
edition.work.authorships.authorizable.profile.surname], :as =>
:author, :sortable => true
indexes [edition.short_description,
edition.long_description], :as => :description
indexes [edition.abstract], :as => :abstract
has products.media_type(:id), :as => :mt
has products.price, :as => :price
has date_published, :as => :date_published
has imprint_id, :type => :integer, :as => :imprint
has edition.work.work_type(:id), :type => :integer, :as => :pt
end
The following query returns 3 records which is correct. It matches the :mt
and :pt attributes correctly.
Publication.search(nil, :match_mode => :extended, :sort_by =>
:date_published, :with => { :pt => 3, :mt => 2 })
However the following query returns 2 records when it shouldn't return any.
Each Publication has 2 products in the association. Each of the association
results match either the :mt attribute or the :price attribute but not both,
one has the correct :mt value but the :price is to high and the other has
the wrong :mt value but the :price is within the range.
Publication.search(nil, :match_mode => :extended, :sort_by =>
:date_published, :with => { :pt => 3, :mt => 2, :price => (0..5) })
Can someone tell me what I am missing? I am using postgresql 8.4 and the
latest spinx mac port and the latest thinkingsphinx.
--
Matthew Hinton
[email protected]
http://www.myverbaloutlet.net
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
