Hello Pat, Thats way more interesting than my porposition.
Thanx for the insight ;) Alex On Aug 21, 11:55 am, Pat Allan <[email protected]> wrote: > Hi Alex > > I think your two options are: > * index questions to include answer data, but only get questions > returned in search results (ie: what you're doing now) > * index both questions and answers, and search across both, and get a > mixture of questions and answers returned. > > In the latter situation, you could ensure that only one result per > question is returned by doing the following in Question: > has :id, :as => :question_id > And in Answer > has question_id > > And then for searching: > ThinkingSphinx.search 'query', > :group_by => 'question_id', > :group_function => :attr > > This way, you'll get a mixture of Questions and Answers, but no > duplications of pairs. > > Hope this helps. > > -- > Pat > > On 21/08/2009, at 10:49 AM, Alejandro Riera wrote: > > > > > So, no insights in this topic? > > Any idea will be welcomed :) > > > Thx, > > > Alex > > > On Aug 15, 9:11 pm, Alejandro Riera <[email protected]> wrote: > >> Hello everybody. > > >> I'm very happy with the results of sphinx and TS (thx Pat for it!) > >> but > >> I have a problem I dont manage to resolve. > > >> My case is de following: I have 2 models: questions (Q) and asnwers > >> (A). > >> As you would expect Q has_many A and A belongs_to Q. > > >> What I want is to search inside both Q and A. So what I do right now > >> is the following: > > >> class Question < ActiveRecord::Base > >> has_many :answers > >> define_index do > >> indexes body > >> indexes answers.body, :as => :answers > >> end > >> end > > >> The problem is that if sphinx (or TS I'm not sure) finds a match > >> inside an answer he is going to give me the question containing it > >> (even if the question doesn't matches the query). This might be a > >> little strange from the user point of view: he might see some results > >> that apparently don't match his search query. > > >> What I like to do is to show him the Question and, next to it, the > >> answer(s) containing the match. > > >> I would love TS to give me an array like this: [Q, A, Q, Q, Q, A, > >> A, ....] each answer belonging to the question on his left. > > >> Do you think it is possible to make something like that? > > >> I've tried to be clear presenting the problem, if that's not the case > >> don't hesitate to ask me anything > > >> Thank you a lot > > >> Alex > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
