Hi All, I'm trying to do ranking of a QuerySet efficiently (keeping it a QuerySet so I can keep the filter and order_by functions), but cannot seem to find any other way then to iterate through the QuerySet and tack on a rank. I dont want to add rank to my model.
I know how I can get the values I need through SQL query, but can't seem to translate that into Django: SET @rank = 0, @prev_val = NULL; > SELECT rank, name, school, points FROM > (SELECT @rank := IF(@prev_val = points, @rank, @rank+1) AS rank, > @prev_val := points, points, CONCAT(users.first_name, ' ', users.last_name) > as name, school.name as school > FROM accounts_collegebrainuserprofile > JOIN schools_school school ON school_id = school.id > JOIN auth_user users ON user_id = users.id > ORDER BY points DESC) as profile > ORDER BY rank DESC > I found that if I did iterate through the QuerySet and tacked on 'rank' manually and then further filtered the results, my 'rank' would disappear. Is there any other way you can think of to add rank to my QuerySet? Is there any way I could do the above query and get a QuerySet with filter and order_by functions still intact? I'm currently using the jQuery DataTables with Django to generate a leaderboard with pagination (which is why I need to preserver filtering and order_by). Thanks in advance! Sorry if I did not post my question correctly - any help would be much appreciated. Peter -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/sGtBJsyeLQAJ. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
