Django-ratings error: "rating value must be a Rating instance, not '100"?

Question

Im trying to order a set of model objects by rating with Django-ratings app. I've built a order_by function in my view which works fine but not when i comes to the rating field where im getting this error: "rating value must be a Rating instance, not '100". Any ideas whats wrong with this / or what the error means?

Thank you!

Template:

<a href="/mylist/?order_by=rating">Order by Rating</a>

View:

def Mylist(request):    
    order_by = request.GET.get('order_by', 'created_date')  
    mylist = Mymodel.objects.filter(user=request.user).order_by(order_by)

    if order_by == "rating":
        qs = Mymodel.objects.filter(user=request.user).extra(select={
        'rating': '((100/%s*rating_score/(rating_votes+%s))+100)/2' % (Mymodel.rating.range, Mymodel.rating.weight)
        })
        mylist = qs.order_by('-rating')

    context = {'mylist ': mylist }
    return render_to_response('mylist.html', context, context_instance=RequestContext(request))

Model:

class Mymodel(models.Model):
   user = models.ForeignKey(User)
   created_date = models.DateField(auto_now_add=True)
   type = models.CharField(max_length=50)
   description = models.CharField(max_length=140, blank=True)
   rating = RatingField(range=5)

Please add the definition of `Mymodel` and full stacktrace of the error. — Sunny Nanda, Feb 19 '14 at 18:54
Ok. Mymodel is just a regular class with some different fields where on field is a "ratingfield" called 'rating'. — user3199840, Feb 19 '14 at 21:59

score 1 · Answer 1 · answered Sep 15 '14 at 16:38

1

Try to rename extra attribute 'rating'

queryset = queryset.extra(select={
    'myrating': '((100/%s*rating_score/(rating_votes+%s))+100)/2' % (Mymodel.rating.range, Mymodel.rating.weight)
})
queryset = queryset.order_by('-myrating')

answered Sep 15 '14 at 16:38

djangotango

11
1

This worked for me! The documentation needs to be edited for django-ratings @dcrammer – Mevin Babu Oct 05 '14 at 06:34

Django-ratings error: "rating value must be a Rating instance, not '100"?

1 Answers1