Hmm.. can you share your index definition, and your search query? -- Pat
On 02/01/2012, at 9:14 PM, mohitnegi wrote: > Hi Pat, > > Thanks for the quick help. > Actually I tried the same before but the problem i am facing is that my score > table has these fields. > overall_score > section1_score > section2_score > section3_score > test_id > reg_no (reg_no is unique for each tests_users) > > so the above association as you suggested works perfectly fine and i am > getting all the fields. > But as there are multiple scores and test for a particular candidate so there > will be multiple values, for that i am using > > has user.test_users.score(:overall_score), :as => :overall_scores, > :type=>:multi > > and same for the corresponding subsection scores. > But when i do search, now it matches the search criteria with all the values. > i.e. lets say i want a candidate record who has a overall score of 90 and > section1 of 85. > > But when i give this search criteria my sphinx return those candidate also > who has overall score of 90 in one test and section1 score of more than 85 in > there other test. > But what i want is that it should search for same score record for a > particular condition. > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/thinking-sphinx/-/kgfz9oxygq4J. > 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. -- 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.
