How to filter Django ManyToManyField by Id

Asked Jun 01 '23 at 13:12

Active Jun 01 '23 at 13:20

Viewed 23 times

I have two models:

class Category(models.Model):
        name = models.CharField(max_length=255)

class Company(models.Model):
        name = models.CharField(max_length=255)
        category = models.ManyToManyField(Category, related_name='companies')
        products = models.TextField()
        bulletpoints = models.TextField()
        website = models.CharField(max_length=750)
        articles = models.TextField()

Now I want to filter the Objects in the Company model by the id of the categories, which I put them in.

I tried several options including everything from that question: https://stackoverflow.com/questions/2218327/django-manytomany-filter for example: Company.objects.filter(companies__in=[category_id]) Company.objects.filter(companies__id=category_id) Company.objects.filter(category_id=category_id) Company.objects.filter(companies__id__in=category_id)

edited Jun 01 '23 at 13:20

Willem Van Onsem

443,496
30
428
555

asked Jun 01 '23 at 13:12

Leonhardphilipp Lydkasänger

did you tried `Company.objects.filter(categories__in=[category_id])` this? – PRATHEESH PC Jun 01 '23 at 13:20
1

`Company.objects.filter(category__id=category_id)` – Willem Van Onsem Jun 01 '23 at 13:20
You can try this: `category=request.GET.get('category')` and `if category == None: companies = Company.objects.filter(category__name=category)` – Bamagujen_Bahaushe. Jun 01 '23 at 13:37

How to filter Django ManyToManyField by Id

0 Answers0