JSONField contains in Django

Question

Hi im trying to know if a list contains another list, for this im using django + djongo, but i dont if i'm doing the query correctly

My model is


class Item(models.Model):
    name = models.CharField(max_length= 255)
    _id = models.ObjectIdField(primary_key = True)
    sku = models.JSONField(null= True)
    providers= models.JSONField(null= True)
    generic = models.JSONField(null= True)
    is_validated = models.BooleanField(default = False)
    tags = models.JSONField(null= True)
    objects = models.DjongoManager()

My serializer

class ItemSerializer(serializers.ModelSerializer):
    
    class Meta:
        model = Item
        fields = (
            '__all__'
        )

generic is a list of strings like: ["martillo", "s2","s3","s4"]

I want to get all items which the generic list contains the given list, i'm trying the next query but it returns all the items in database

items = models.Item.objects.filter(generic__contains = ['martillo'])

What i'm doing wrong?

I edited my question, basically i'm trying to get all items which the field generic contains a given list — AlejandroOrostica, Jul 23 '20 at 22:39

score 1 · Answer 1 · answered Jul 23 '20 at 23:12

import operator
from django.db.models import Q

Item.objects.filter(reduce(operator.and_, (Q(generic__contains=x) for x in ["martillo", "s2","s3","s4"] )))

Which is the equivalent of

Item.objects.filter(Q(generic__contains='martillo') & Q(generic__contains='s2') & Q(generic__contains='s3') etc...)

From https://stackoverflow.com/a/4824810/1730167

JSONField contains in Django

1 Answers1