Django queryset filter empty JSONField

Question

I would like to filter a JSONField my_fieldwhere the JSon is not empty. In the documentation there are has_keyand has_any_key methods but I don't know the possible keys in advance. In SQL it should be something like:

select * from my_model where cardinality(my_field)>0;

https://stackoverflow.com/questions/844556/filtering-for-empty-or-null-names-in-a-queryset — hansTheFranz, Jun 18 '20 at 09:48
This filter null value. I want to filter empty json (json with a size of 0) — Othman, Jun 18 '20 at 09:49

score 4 · Answer 1 · answered Jun 18 '20 at 12:37

4

Found a way to achieve using iexact:

MyObject.objects.filter(my_field__iexact="{}")

answered Jun 18 '20 at 12:37

Othman

332
5
19

score 0 · Answer 2 · answered Apr 03 '23 at 14:52

0

according to the docs you can use

MyModel.objects.include(myjsonfield__exact=[])
MyModel.objects.exclude(myjsonfield__exact=[])

answered Apr 03 '23 at 14:52

pymen

5,737
44
35

Django queryset filter empty JSONField

2 Answers2