Question

0

309

Visualizações

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 Respostas

Responde à pergunta

0

Responde à pergunta

Encontrar trabalhos remotos

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

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

over 4 years ago · Santiago Trujillo Relatório

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

309

Django, JSONField, filter for non empty list

2 Respostas

0

0

Encontrar trabalhos remotos

Andres GPT