一个表过滤器对我来说很好，但这里我需要在django中过滤两个表过滤器，这不起作用

Question

models.py:

class Department(models.Model):
department_id = models.AutoField(primary_key=True)
department_n_key = models.CharField(max_length=30,blank=True,unique=True)
hospital_short_name = models.CharField(max_length=20)
department_name = models.CharField(max_length=50)
class EmployeesMaster(models.Model):
employee_id = models.AutoField(primary_key=True)
employee_n_key = models.CharField(max_length=30,blank=True,unique=True)
first_name = models.CharField(max_length=30)
middle_name = models.CharField(max_length=30, blank=True, null=True)
last_name = models.CharField(max_length=30, blank=True, null=True)
gender = models.CharField(max_length=12, blank=True, null=True)
class PatientMaster(models.Model):
patient_id = models.AutoField(primary_key=True)
patient_n_key = models.CharField(max_length=30,blank=True,unique=True)
first_name = models.CharField(max_length=30)
middle_name = models.CharField(max_length=30, blank=True, null=True)
last_name = models.CharField(max_length=30, blank=True, null=True)
age = models.IntegerField(blank=True, null=True)

views.py

我需要在django:中应用这个

从appointment_master中选择*，其中patient_type="测量"和appointment_master。department_n_keyIN(从department中选择department.department_n_key，其中department.department_name="测量"(

帮助某人将此应用于django

Answer 1

这不是最优的，但您可以在两个查询中完成

departments_list= Department.objects.filter(departmen_name='foo').values_list('department_n_key', flat=True)
apointment_master = YourModel.objects.filter(patient_type='bar', department_n_key__in=departments_list)