How can I display something from data base after multiple criteria is satisfied in django

Using Django Using the ORM
1

Here I have a Model Recommenders:

class Recommenders(models.Model):
    objects = None
    Subject = models.ForeignKey(SendApproval, on_delete=models.CASCADE, null=True)
    Recommender = models.CharField(max_length=20, null=True)
    Status = models.CharField(null=True, max_length=8, default="Pending")
    Time = models.DateTimeField(auto_now_add=True)

And another model Approvers:

class Approvers(models.Model):
    objects = None
    Subject = models.ForeignKey(SendApproval, on_delete=models.CASCADE, null=True)
    Approver = models.CharField(max_length=20, null=True)
    Status = models.CharField(null=True, max_length=8, default="Pending")
    Time = models.DateTimeField(auto_now_add=True)

And my SendApproval model is as:

class SendApproval(models.Model):
    Subject = models.CharField(max_length=256)
    Date = models.DateField(null=True)
    Attachment = models.FileField(upload_to=get_file_path)
    SentBy = models.CharField(null=True, max_length=100)
    Status = models.CharField(null= True, max_length=8, default="Pending")

Now my problem is that I have to display the Subject and Attachment from the SendApproval table only when all the recommender’s Status in the Recommenders table related to that subject is “Approved” Don’t know how can I know that…Thanks in advance…

Actually not have any Idea about the solution but the best answer will be appreciated…By the way, I am new here…So please let me know if there is some ambiguity in my question.

2

The basic idea is that you would write your query with the proper filter (or exclude) clauses to limit the results to the rows that you are interested in.

If necessary, review the work you would have done in the Playing with the API section of the tutorial, along with the Making queries docs.