Hi, I have the following simplified product datamodel:
id, name, group_id, category_id and I have a facet defined on the category that allows me to find out the actual number of products within a category. What I like to know is, how many distinct groups (-> group_id) I have within a category. For example: 1, 'Product A', 'Group A', 'Category A' 2, 'Product B', 'Group A', 'Category A' 3, 'Product C', 'Group C', 'Category B' 4, 'Product D', 'Group D', 'Category B' What I currently get is: Category A (2) Category B (2) What I like to get is: Category A (1) Category B (2) ------ Is there a way to do this with thinkingsphinx and its facets support? I looked at the sphinx docs and found the SetGroupDistinct function (http://sphinxsearch.com/docs/manual-0.9.9.html#api-func- setgroupdistinct) that seems to be a solution to my problem. Is there a way to use it in thinkingsphinx? Thanks for your help, Andre -- 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.
