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.
