Hi
TS does not support custom queries (has 'select xy from ....') and
facets (http://groups.google.com/group/thinking-sphinx/browse_thread/
thread/3649da7e8afb52a1#). If you do not need facets, then something
like this should work:
has '(select group_concat(gf.id) from geographic_features gf where
gf.lft <= geographic_features.lft and gf.rgt >=
geographic_features.rgt)',
:as => :geographic_feature_ids,:type => :multi
GeographicFeature is a nested_set (with lft/rgt) and the subselect
makes use of the geographic_features table. For geographic_features to
be known it must be included in the query (i.e. also add indexes
geographic_features(:name) )
Pascal
On Aug 26, 1:59 pm, mix <[email protected]> wrote:
> Hi mrmanishs, for now i've found some kind of
> solution:http://groups.google.com/group/thinking-sphinx/browse_thread/thread/e...
> But an help to improve it from the thinking_shipnx gurus would be
> greatly appreciated ;) (maybe without saving the categories in a
> column but generate them with a query during the indexing... like the
> one above, if it's possible... after hours of work and trying i've not
> found a way to make it work :( )
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
