Find position in active record object

Question

I have a league table that i create with:

 QuizuserAnswer.all(:include =>:user, :select => 'user_id, SUM(answer) AS points', :group =>'user_id', :order=>'points DESC'

This returns an object like this:

 => [#<QuizuserAnswer user_id: 340>, #<QuizuserAnswer user_id: 348>]

Now i want to find the league table position of one specific user. Is there a clean way? or do i have to loop through al columns?

Answer 1

From a very little i got your question i think you want something like following

answers = QuizuserAnswer.all(:include =>:user, :select => 'user_id, SUM(answer) AS points', :group =>'user_id', :order=>'points DESC')
user_id = 348
answers.map(&:user_id).index(user_id) #This will return 1

i.e It will return the position of the answer given by the user among the answer's list