Query a queryset from a django Foreign key connected model

Question

I have a model like the following:

class Flow(models.Model):

    flow_type_choices = (('Static', 'Static'), ('Transit', 'Transit'), ('Circuit', 'Circuit'), ('Close', 'Close'))

    flow_name = models.CharField(max_length=500, default=0)
    flow_info = models.CharField(max_length=500, default=0)

    flow_type = models.CharField(max_length=500, default=0, choices=flow_type_choices)
    flow_days = models.IntegerField(default=0)
    sender_client = models.ForeignKey(Client, on_delete=models.CASCADE)
    receiver_client = models.ForeignKey(ReceiverClient, on_delete=models.CASCADE)

I am trying to get the queryset of receiver_client attached to a particular sender client

For this I have tried the following:

         items = list(Flow.objects.filter(sender_client=request.user.pk).
                 values_list('receiver_client', flat=True).distinct())
    print("items", items)
    rc = ReceiverClient.objects.filter(pk__in = items)

and I am getting :

items <QuerySet [11, 8, 7, 18, 4, 6, 3]>

How can I get the queryset of the receiver clients instead of the pk ?

Iain Shelvington · Accepted Answer · 2021-04-14 06:29:30Z

4

You can get this data in a single query by following the relationship all the way from ReceiverClient to Client

ReceiverClient.objects.filter(flow__sender_client=client)

answered Apr 14, 2021 at 6:29

Iain Shelvington

32.5k3 gold badges36 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query a queryset from a django Foreign key connected model

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related