Django，JSONField，过滤非空列表

Question

我有一个 jsonfield

foo = JSONField(default=list)

我想过滤查询集，以便 foo 有一些数据(不是空列表)

我试过了

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

Answer 1

您应该能够通过使用 Q 否定相等来测试不等式。对象。

from django.db.models import Q

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