CODEWITHSUNDEEP
pythondjango
linmu
linmu

Reputation: 45

How can I find reporters who wrote at least one articles using django orm?

below are models:

from django.db import models

class Reporter(models.Model):
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    email = models.EmailField()

    def __str__(self):              # __unicode__ on Python 2
        return "%s %s" % (self.first_name, self.last_name)

class Article(models.Model):
    headline = models.CharField(max_length=100)
    pub_date = models.DateField()
    reporter = models.ForeignKey(Reporter, on_delete=models.CASCADE)

    def __str__(self):              # __unicode__ on Python 2
        return self.headline

    class Meta:
        ordering = ('headline',)

How can I find reporters who wrote at least one articles using Django orm?

Upvotes: 0

Views: 169

Answers (1)

neverwalkaloner
neverwalkaloner

Reputation: 47354

You can filter reporters using isnull:

Reporter.objects.filter(article__isnull=False).distinct()

Upvotes: 2

Related Questions