Counting the total occurrences of terms

[Dandan]

Hi,

I'm trying to get the total occurrences that a search term appears in
text. For example if the search term is "blue" and I have two records
to search: "the blue blue sky" and "a blue day under a blue sky" I
would want a total of 4.

If possible from there, in some cases I will be grouping the totals of
word by another field in the table.

Any ideas? Thanks!

[Pat Allan]

Hi

I'm afraid Sphinx doesn't provide that level of detail - you'd have to scan through the results yourself to figure out how many times it matched in the Ruby side of things.

--
Pat

> --
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
>

[Timo Virkkala]

Hi Dandan,

Wouldn't ThinkingSphinx::Search#results[:words] do what you need?

ThinkingSphinx.search('blue').results[:words]
=> {"blue"=>{:docs=>2, :hits=>4}}

-T-

[Dandan]

Hey Timo,

Yip results[:words] did the trick. I haven't yet been able to see how
to split that up based on facets which I would like to use for
graphing data yet though. If you have any ideas let me know, otherwise
thanks for the initial answer.

Dan