Using a Query instead of a for loop

Question

Is there a way to do the following in a single line with a django query?

providers_with_no_contacts = []
for provider in Provider.objects.all():
    if not provider.userprofile_set.all():
        provider_with_no_contacts.append(provider)

Or a better way than this?

providers_with_no_contacts = [provider for provider in Provider.objects.all() 
                               if not provider.userprofile_set.all()]

animuson · Accepted Answer · 2012-02-23 18:02:42Z

1

Provider.objects.filter(userprofile__isnull=True)

edited Feb 23, 2012 at 18:02

animuson♦

54.9k28 gold badges142 silver badges150 bronze badges

answered Feb 8, 2012 at 4:02

David542

112k211 gold badges581 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bernhard Vallant · Accepted Answer · 2012-01-26 21:22:45Z

0

providers_with_no_contacts = Provider.objects.filter(userprofile_set=None)

answered Jan 26, 2012 at 21:22

Bernhard Vallant

50.9k21 gold badges126 silver badges149 bronze badges

2 Comments

David542 Over a year ago

That didn't work. Perhaps it is because userprofile is a M2M field?

Chris Pratt Over a year ago

Try: .filter(userprofile__isnull=True). Works whether the field is a foreign key or M2M.

Collectives™ on Stack Overflow

Using a Query instead of a for loop

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related