0
class Profile(models.Model):
    ..
    goldcoin = models.IntegerField(default=0)

    likes = models.ManyToManyField(User, blank=True, related_name='user_like')
    dislikes = models.ManyToManyField(User, blank=True, related_name='user_dislike')

    def __str__(self):
        return self.user.username
    
    def get_avatar(self):
        ..

from likes = models.ManyToManyField(User, blank=True, related_name='user_like') How to get Highest Likes User?

Example i have user like this

  • User Likes
  • Jhon 30
  • Aish 25
  • Josh 5
  • Adam 50

Output

  • User Likes
  • Adam 50
  • Jhon 30
  • Aish 25
  • Josh 5

Django 4.0.6 Python 3.10.2

Sunderam Dubey
  • 1
  • 11
  • 20
  • 40
Smile Pumpkin
  • 3
  • 1

1 Answers1

0

You can aggregate a total number of likes using Count, then order the queryset by total number of likes in the following way:

from django.db.models import Count

profiles = Profile.objects.annotate(total_likes=Count('likes')).order_by('total_likes')
Sunderam Dubey
  • 1
  • 11
  • 20
  • 40
Ersain
  • 1,466
  • 1
  • 9
  • 20