Django filter queryset __in=list for every item in queryset

Question

Let's say I have the following models

class Offer(models.Model):
    skills_required = models.ManyToManyField(Skill, blank=True)

class Skill(models.Model)
    title = models.CharField(max_length=80, primary_key=True)

class UserProfile(models.Model):
    skills = models.ManyToManyField(Skill)

How can I filter Offer.objects with an instance of UserProfile in a way that skills_required of remaining offers would be a subset of user_profile.skills?

willeM_ Van Onsem · Accepted Answer · 2021-08-18 15:22:52Z

2

We can count the number of required skills for that offer, and check if the number of skills is equal to the number of skills for that userprofile with:

from django.db.models import Count, F, Q

Offer.objects.alias(
    req_skill=Count('skills_required', distinct=True),
    skills=Count(
        'skills_required',
        filter=Q(skills_required__userprofile=my_userprofile),
        distinct=True
    )
).filter(
    req_skill=F('skills')
)

For Django prior to django-3.2, you should use .annotate(…) [Django-doc] instead of .alias(…) [Django-doc].

answered Aug 18, 2021 at 15:22

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

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

Collectives™ on Stack Overflow

Django filter queryset __in=list for every item in queryset

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