CODEWITHSUNDEEP
pythondjangodjango-models
Pratik Poddar
Pratik Poddar

Reputation: 1345

Django Filter by Foreign Key

class UserTomonotomo(models.Model):

    userid= models.BigIntegerField(null=False, unique=True, db_index=True)
    email= models.CharField(max_length=100L, null=True)
    ######################
    ########

class UserFriends(models.Model):
    userid= models.ForeignKey('UserTomonotomo', to_field='userid', null=False)
    friendid = models.BigIntegerField(null=False)

I need to search for UserFriends whose userid > 0,

 UserFriends.objects.filter( userid__userid > 0 )

does not work as posted in Django - filtering on foreign key properties !! What's the fix. I am using django version 1.5.2

Thanks

Upvotes: 1

Views: 2399

Answers (1)

falsetru
falsetru

Reputation: 369064

use __gt:

UserFriends.objects.filter(userid__userid__gt=0)

See QuerySet API Referenece - Field lookup for other operators.

Upvotes: 5

Related Questions