user4374121
user4374121

Reputation:

How to filter foreign key related by user?

How do i filter this ?

class Base(models.Model):
    user = models.ForeignKey(User)
    base_name = models.CharField(max_length=100)

class Sub_base(models.Model):
    base = models.ForeignKey(Base)
    sub_base_name = models.CharField(max_length=100)

Now i just want to filter Sub_base based on current logged in user , how to do that ?

Upvotes: 0

Views: 34

Answers (1)

doniyor
doniyor

Reputation: 37876

if request.user.is_authenticated(): 
   subbases = Sub_base.objects.filter(base__user=request.user)

if request.user.is_authenticated(), then this user is logged in, otherwise the user is Anonymous User

Upvotes: 2

Related Questions