If it helps, I ended up doing a brute force approach, where I got the facet results, and broke it down if it had a parent or not, and counted the parent and the child values separately into my display...
Manish On Aug 27, 8:22 pm, Pat Allan <[email protected]> wrote: > Sorry I've not gotten to this thread sooner - things are a little flat > out at the moment, and it's one of the more complex topics. > > At this point in time, facets doesn't really work for SQL snippets - > because TS isn't sure what the snippets return (a string? an integer? > something else?). Ideally, for non-string attributes, it should just > use the underlying Sphinx value (instead of translating it via Ruby > objects, which is where the error messages come from), but this > obviously isn't the case at the moment. > > Beyond that, I'm really not sure how to help (granted, I've not dealt > with nested sets and TS before). > > -- > Pat > > On 27/08/2009, at 3:48 PM, mix wrote: > > > > > Unfortunately i need facets too, btw i've tried with has 'sql select' > > and it's not working quite good (having the category on another > > association, like "article"->"article_detail"->"category"... i've > > tried bot with categories.lft and article_details.categories.lft > > > With the solution i've found facets works correctly, but unfortunately > > it takes too much to load (from 0.3 to 1.5 seconds, just for it) with > > just 100k objects in the db > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
