Query the same object multiple times in Django view

Asked Jun 12 '16 at 21:07

Active Jun 12 '16 at 21:20

Viewed 137 times

If I want to query all users of the whole alphabet could I do this in a view or do I run into a lot of performance issues?

users_a = User.objects.filter(username__startswith="a")
users_b = User.objects.filter(username__startswith="b")
users_c = User.objects.filter(username__startswith="c")
users_d = User.objects.filter(username__startswith="d")
users_e = User.objects.filter(username__startswith="e")

To clarify what I want to achieve:

My view:

def site_list(request):
    from django.contrib.auth.models import User
    users_a = User.objects.filter(username__startswith="a")
    return render(request, 'lists/sites.html', {'users_a': users_a})

My template:

<div class="col-md-12">
<h3>A</h3></div>
{% for user in users_a %}
  <div class="col-md-3">
    <a href="{% if request.is_secure %}https{% else %}http{% endif %}://{{ user.username }}.{{ request.get_host }}">
      <img class="avatar" src="{% avatar_url user 60 %}" alt="#">
      <span class="title">{{ user.first_name }} {{ user.last_name }}</span>
      <span class="url">{{ user.username }}.domain.com</span>
    </a>
  </div>
{% endfor %}

edited Jun 12 '16 at 21:20

asked Jun 12 '16 at 21:07

Droadpc

1

Why don't you query all users and sort them alphabetically? – raphv Jun 12 '16 at 21:12
What do you want to achieve? – Jose Romero Jun 12 '16 at 21:12
@raphv and Jose. I want to query first all of the users in a div with the letter A then query B in another div and so forth. It will be different styles in each div. Otherwise I probably could do it in one query. – Droadpc Jun 12 '16 at 21:13
views don't have any divs, only the template does, what are you actually trying to do? group by first letter? – Sayse Jun 12 '16 at 21:17
1

Maybe this will help you: http://stackoverflow.com/questions/4151631/django-grouping-queryset-by-first-letter – Jose Romero Jun 12 '16 at 21:20
@JoseRomero Wooow, that really was what I needed. Thank you man! – Droadpc Jun 12 '16 at 21:37

Query the same object multiple times in Django view

0 Answers0