Dynamic Faceting With Thinking Sphinx

[Abhishek jain]

Hi,

In my project I need a functionality based on dynamic faceting. 

Something like:

Lets say we have 4 models product, variants, option types and option values

OptionType has_many => option_values

Variant has_many => option_values

Product has_many => option_types

Product has_many => variants

I need to facet option type having its facet values as option_values

And option values are linked with product objects.

Example.

Color (Option Type)

  -> Red (Option Value)

  -> Green (Option Value)

  -> Blue (Option Value)

Product has option type Color and variant has option value as Red.

Hence faceted value should be

Color

- Red (1)

Now, when I add another option type, lets say Size.

with option values.

Size (Option Type)

  -> L (Option Value)

  -> XL (Option Value)

  -> XXL (Option Value)

And link Size with product and XL with one of the variant, then

Result should be something like,

Color

- Red(1)

- Green(0)

- Blue(0)

Size

- L (0)

- XL (1)

- XXL (0)

Is it possible to do this with ThinkingSphinx? 

[Pat Allan]

I don’t think anything like this is possible, I’m afraid. Sphinx faceting is done by grouping on attributes, so you’d need each facet to be defined as an attribute, which means you need to know what they are when configuring Sphinx.

Also, Sphinx has no concept of a hash/dictionary data type, so for a Product, you couldn’t have option types have option values, let alone distinguish between them on a variant level. That said, you could search on OptionType instead… but you still have the above issue to deal with.

For reference, it’s worth noting that Sphinx has an inbuilt FACET function from 2.2.3 (2.2.x releases are considered betas):

http://sphinxsearch.com/blog/2014/05/22/the-facet-feature/

But that doesn’t address the issue I’ve covered.

One thing that *might* help - it’d require some investigation, though - is the JSON support in Sphinx since version 2.1.1-beta:

http://sphinxsearch.com/blog/2013/08/08/full-json-support-in-trunk/

I’ve not really played with it, but maybe that would allow the types of queries you need to group by specific values, if a Product or Variant’s option types and option values are stored as JSON in Sphinx? This is probably the only path worth investigating, but I can’t guarantee if it’ll work or not.

— 

Pat

--
You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thinking-sphi...@googlegroups.com.
To post to this group, send email to thinkin...@googlegroups.com.
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.