How to extract active user email address from Django

Question

I want to extract a list of active users email addresses from Django's Home › Authentication and Authorization › Users page and put it into a template. Can someone help me achieve this?

So far I'm trying to do something like this:

from django.contrib.auth.models import User

if User.is_active:
    emails = User.objects.get(email=request.user.email)

Are you asking for help with the query, or the view itself? And if the view, what aspects? — CoolestNerdIII, May 03 '18 at 13:13

Ashish Acharya · Accepted Answer · 2018-05-03T13:18:18.420

10

Here's how to get a list of email addresses for active users:

emails = User.objects.filter(is_active=True).values_list('email', flat=True)

If you want to exclude empty email addresses, you can do it like this:

emails = User.objects.filter(is_active=True).exclude(email='').values_list('email', flat=True)

edited May 03 '18 at 13:18

answered May 03 '18 at 13:14

Ashish Acharya

3,349
1
16
25

3

The list comprehension seems unnecessary, just use `values_list('email', flat=True)`. – Daniel Roseman May 03 '18 at 13:16
Thanks! Updated it. – Ashish Acharya May 03 '18 at 13:18

score 1 · Answer 2 · answered May 03 '18 at 13:18

1

You can select email only from active users using this query.

from django.contrib.auth.models import User

emails = User.objects.filter(is_active=True).values_list('email', flat=True)

answered May 03 '18 at 13:18

Adriano Silva

2,518
1
17
29

score 0 · Answer 3 · answered May 03 '18 at 13:16

0

One solution :

email_list = User.objects.filter(is_active=True).values_list("email", flat=True)

See the doc on values_list for more information.

answered May 03 '18 at 13:16

stellasia

5,372
4
23
43

How to extract active user email address from Django

3 Answers3