相关的字段Django Orm显示了多个无效的结果

Question

查询

TechnicianAssignment.objects.filter(Q(slot__slot_date=curr_datetime.date())&Q(assigned_technician__attendance_Technician__attendance_status__in=['Rejected', 'Absent', 'Someone else reported', 'Present']))

模型简而言之：

**Table 1**:
class TechnicianTeam(models.Model):
id = models.AutoField(primary_key=True)
supervisor = models.ForeignKey('self', null=True, blank=True, related_name="TechnicianSupervisor", on_delete=models.DO_NOTHING)
customer_profile = models.ForeignKey('login.CustomerProfile',
                                    related_name="technician_TeamUser", on_delete=models.DO_NOTHING)

class Meta:
    db_table = "technician_team"


**Table2:**
class TechnicianAssignment(models.Model):
    id = models.AutoField(primary_key=True)
    slot = models.ForeignKey('technician_management.TechnicianSlot',
                                        related_name="assignment_Slot", on_delete=models.DO_NOTHING)
    assigned_technician = models.ForeignKey('technician_management.TechnicianTeam',
                                        related_name="assignment_Technician", on_delete=models.DO_NOTHING)
    class Meta:
        db_table = "technician_assignment"
**Table3**
ATTENDANCE_CHOICES = [
    ('Rejected','Rejected'),
    ('Someone else reported','Someone else reported'),
    ('Absent','Absent'),
    ('Present','Present')
]
    class TechnicianAttendance(models.Model):
        id = models.AutoField(primary_key=True)
        technician = models.ForeignKey('technician_management.TechnicianTeam',
                                        related_name="attendance_Technician", on_delete=models.DO_NOTHING)
        slot = models.ForeignKey('technician_management.TechnicianSlot',
                                            related_name="attendance_Slot", on_delete=models.DO_NOTHING)
        attendance_status = models.CharField(max_length=30, choices=ATTENDANCE_CHOICES, null=True)
    class Meta:
        db_table = "technician_attendance"

询问我的查询问题是什么：

我需要从TechnicianAssignment中滤除条目中的“ slot__slot_date”是当前日期和“ __attendance_technician __attendance_attendance_attendance_attendance_status_status__in” ，“其他人报告”，“存在”]

DB中只有1个条目“出席状态”，但是由于“ ____tendance_technician __attendance_statuse_status__in”，我的输出很多。