Django ORM querying nested models

Question

I want to use django ORM to filter some records from db, I have a model named User which contain a field profile which is another model, When I do the following I get all the users having a profile:

users = User.objects.filter(Q(profile__isnull=False))

profile has a field age I want to delete all the users with a profile and age>30. So I looped through all the users with a profile and then checked if their age is > 30.

for user in  users:
    if user.profile.age>30:
          user.delete()

Is there a way to use user.profile.age>30 directly in querying?

Try: User.objects.filter(Q(profile__isnull=False) & Q(profile__age__gt=30)) — Harun Yilmaz
– Harun Yilmaz, Commented Sep 4, 2020 at 8:04

Harun Yilmaz · Accepted Answer · 2020-09-04 13:26:08Z

2

I solved the problem by combining Q objects from Django as followings:

User.objects.filter(Q(profile__isnull=False) & Q(profile__age__gt=30))

edited Sep 4, 2020 at 13:26

Harun Yilmaz

8,5793 gold badges30 silver badges40 bronze badges

answered Sep 4, 2020 at 9:42

Agus Mathew

9511 gold badge10 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Django ORM querying nested models

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related