How to filter multiple values for same column

Question

from django.contrib.auth.models import User    
...
resolvers = User.objects.filter(groups__name = 'resolver')

above code is to filter user belongs to group resolver, in this I need to retrieve users those belongs to admin group as well.

I tried

resolvers = User.objects.filter(groups__name = 'resolver' or 'admin')
resolvers = User.objects.filter(groups__name = ('resolver','admin'))

both are failing, please help.

Answer 1

You can use __in:

resolvers = User.objects.filter(groups__name__in = ('resolver','admin'))

or Q object to implement OR condition:

from django.db.models import Q
resolvers = User.objects.filter(Q(groups__name='resolver')| Q(groups__name='admin'))