Question

0

307

Views

Django, JSONField, filter for non empty list

I have a jsonfield

foo = JSONField(default=list)

I want to filter queryset so that foo has some data (not empty list)

I've tried

MyModel.objects.filter(foo__ne=[])  # doesn't seem to work
MyModel.objects.filter(foo__gt=[])  # seems to work but can't be sure if it's the right approach

over 4 years ago · Santiago Trujillo

2 answers

Answer question

0

Answer question

Find remote jobs

Answer 1 · 2022-05-11T20:45:08.475Z

MyModel.objects.exclude(foo=[]))

over 4 years ago · Santiago Trujillo Report

Answer 2 · 2022-05-11T20:45:08.492Z

You should be able to test inequality by negating equality using Q objects.

from django.db.models import Q

MyModel.objects.filter(~Q(foo=[]))

0

307

Django, JSONField, filter for non empty list

2 answers

0

0

Find remote jobs

Andres GPT