Django models filter by foreignkey

class Profile(models.Model):
    user = models.OneToOneField(User)

If we want users with emeil not in gmail service:
Profile.objects.filter(~Q(user__email__contains='@gmail.com'))
If we want users with emeil in gmail service:
Profile.objects.filter(user__email__contains='@gmail.com')


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s