CODEWITHSUNDEEP
django
user18075594
user18075594

Reputation: 75

How to get QuerySet of ForeignKey field Django

I have two models. First one:

class KvantMessage(models.Model):
    text        = models.TextField(blank=True)
    style_text  = models.TextField(blank=True)
    receivers   = models.ManyToManyField(MailReceiver)
    date        = models.DateField(default=timezone.now)
    files       = models.ManyToManyField(FileStorage, blank=True)
    title       = models.CharField(max_length=120, default='Письмо')
    sender      = models.ForeignKey(KvantUser, on_delete=models.CASCADE, related_name='sender')

And second one:

class ImportantMail(models.Model):
    user = models.ForeignKey(KvantUser, on_delete=models.CASCADE)
    mail = models.ForeignKey(KvantMessage, on_delete=models.CASCADE)

The question is, how to get all mails instances as "KvantMails" from "ImportantMail" where user is equal to some user.

P.S. Hope you understand my question

Upvotes: 1

Views: 36

Answers (1)

willeM_ Van Onsem
willeM_ Van Onsem

Reputation: 477676

You can .filter(…) [Django-doc] with:

KvantMessage.objects.filter(importantmail__user=some_user)

One can use double underscores (__) to look "through" relations.

Upvotes: 1

Related Questions