How to create a queryset to filter jsonb fields with __ in key name

14 views
Skip to first unread message

Rakesh Ranjan

unread,
May 8, 2019, 10:48:43 PM5/8/19
to Django users
I have a jsonb field in one of my django model. There are few key value pairs in this json in table with __ in key name. Eg json:
```
data: {'base_cover__tenure': 2,
 'base_cover__variant': '125 Z',
}
```
How can I create a queryset to filter on these fields?
I have tried this  ```MyModel.objects.filter(data__base_cover__tenure__gte=1)```, which obviously doesn't work.
Reply all
Reply to author
Forward
0 new messages