Hi,

I want to do something like this en index definitions :

define_index do
  indexes taxons.name, :as => :product_taxon, :facet =>
true, :conditions => { :taxonomy_id => 1 }
end

This thing could be translate into this :

LEFT OUTER JOIN `taxons` ON (`taxons`.id = `products_taxons`.taxon_id
AND taxonomy_id=1  )

Is this possible ?

Actually i make this to work :
define_index do
  indexes taxons.name, :as => :product_taxon, :facet => true
  where "taxons.taxonomy_id=1"
end

But If a product don't have taxon the product is missing ...

-- 
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.

Reply via email to