Django Traverse Foreign Keys

У меня есть 3 модели, и я пытаюсь создать приборную панель со списком Trials, который охватывает все клиентские сессии для определенного клиента, выбранного с помощью фильтра.

Вот модели:

class Trial(models.Model):
    behavior_name = models.ForeignKey(Behavior, on_delete=models.CASCADE)
    client_session = models.ForeignKey(Client_Session, on_delete=models.CASCADE)
    frequency_input = models.PositiveIntegerField(default=0, blank=True)
    duration_input = models.DurationField(blank=True, default=timedelta(minutes=0))


    class Meta:
        verbose_name_plural = 'trials'

    def __str__(self):
        return str(self.id)


class Client_Session(models.Model):
    name = models.CharField(max_length=200, null=False)
    session_date = models.DateField(blank=False,null=False)
    client = models.ForeignKey(Client, on_delete=models.CASCADE)
    behaviors = models.ManyToManyField(Behavior, null=False)
    therapist = models.ForeignKey(get_user_model(), on_delete=models.CASCADE)

    class Meta:
        verbose_name_plural = 'clientsessions'

    def __str__(self):
        return self.name



class Client(models.Model):
    #user = models.ForeignKey(User, on_delete=models.CASCADE)
    first_name = models.CharField(max_length=200)
    last_name = models.CharField(max_length=200)
    date_of_birth = models.DateField(blank=True, null=True)
    gender = models.CharField(max_length=10, choices=GENDER_CHOICES,blank=True)
    gaurdian_first_name = models.CharField(max_length=200, blank=True)
    gaurdian_last_name = models.CharField(max_length=200, blank=True)
    diagnosis = models.CharField(max_length=200, choices=DIAGNOSIS_CHOICES, blank=True)
    therapist = models.ForeignKey(get_user_model(), on_delete=models.CASCADE)

    def __str__(self):
        return self.last_name

Вот представление, которое я пытаюсь создать

def dashboard(request):
    # filter list of client sessions by selected client
    client_sessions = Client_Session.objects.filter(therapist=request.user)
    client = DashboardClientFilter(request.GET, queryset=client_sessions)
    client_sessions = client.qs

    #Create list of Trials across Client Sessions for the filtered client
    trial_list = Trial.objects.filter()

У вас ошибка filter query you used Filter data. Ожидается queryset.

Изменить, trial_list = Trial.objects.filter(client_session__client=client) в

trial_list = Trial.objects.filter(client_session__client__in= client_sessions)
Вернуться на верх