Order a django queryset with specific objects first

user_10192845 0
Viewed 2952

I have a list of users displaying in templates like the following.

{% for u in users_list %}

    {{u.name}}

{% endif %}

Is there a way to rank two or more users at the top If I want to?

For instance with one user, when the current user visits that list, I can rank him in the top without a specific ordering by excluding me before sending the variable to template.

1) me
2) user2
3) user3
django-queryset django-models django
3 Answers

If you want to order specific objects by id at the top of a queryset, you can order on a conditional expression - for example, to put the current user at the top, and order other users by name:

from django.db.models import Case, When
from django.contrib.auth.models import User

users = User.objects.order_by(
    Case(When(id=request.user.id, then=0), default=1),
    'last_name',
    'first_name'
)

To put multiple objects at the top, just adjust the When condition:

ids_at_top = [1, 2]
users = User.objects.order_by(
    Case(When(id__in=ids_at_top, then=0), default=1))

I would also consider though whether you can achieve what you want via simpler means - for example you could get the current user, exclude them from the main queryset, and then display separately in the template, like this

# in the view
current_user = request.user
users = User.objects.exclude(id=current_user.id)

# in the template
{{ current_user.name }}
{% for u in users %}
  {{ u.name }}
{% endif %}
user_1360100

In your view create a list of users that you want to display. In order to display the current user you can use request.user to get the current user and append them to the list followed by the rest of the users. In your template you would do

<ol type="1">
{% for u in users_list %}

    <li>{{u.name}}<li>

{% endif %}
</ol>

should out what you are looking for

Update example

user_list = list(Users.objects.filter(name="Test")) #Or how ever you want to get the users.
user_list.insert(0,request.user)

if you wanted to get another individual you would just get the user using

another_person = User.objects.get(id=some_id)
user_list.insert(0,another_person)
user_63176080

Usign the queryset you can order your users_list based on the fields in the User. For this purpose you have the sort method in the queryset. In your case seems to me you need to add a field so you can sort by that field. For example you add a rank field default 0 and than add a value for the hightest rank.

The full example is defined here: https://docs.djangoproject.com/en/2.1/topics/auth/customizing/#a-full-example

In your CustomUserMdel just add a field rank = models.IntegerField(default=0)

Then in your view you need to sort by rank:

from django.contrib.auth import get_user_model

User = get_user_model()

# in your view...
user_list = User.objects.all().sort_by('rank')
user_16402130
Related