How can i filter objects for multiple values in Python Django?

Question

I am trying to filter Objects in django for a query set instead of a single value. Please see my code below

@api_view(['GET'])
def getOffersReceived(request, name):
    owner = Profile.objects.get(name=name)
    dogs = Dog.objects.filter(owner=owner)
    print(dogs)

    sittings = Sitting.objects.filter(dog=dogs)

    return Response()

The print(dogs) line is showing a query set of 4 values. The next step I am trying to get all the sittings that have value dog matching either one of the items in the query set.

I am getting the following error:

ValueError: The QuerySet value for an exact lookup must be limited to one result using slicing.

any help would be greatly appreciated.

Thank you

willeM_ Van Onsem · Accepted Answer · 2022-09-29 19:42:41Z

2

You can filter directly with:

@api_view(['GET'])
def getOffersReceived(request, name):
    sittings = Sitting.objects.filter(dog__owner__name=name)
    # …
    return Response()

answered Sep 29, 2022 at 19:42

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

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

Comments

YKL · Accepted Answer · 2022-09-29 23:55:27Z

2

You should use in to filter the queryset: https://docs.djangoproject.com/en/3.2/ref/models/querysets/#in

sittings = Sitting.objects.filter(dog__in=dogs)

answered Sep 29, 2022 at 23:55

YKL

5422 silver badges9 bronze badges

Collectives™ on Stack Overflow

How can i filter objects for multiple values in Python Django?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related