How to query json field django

>>> Dog.objects.create(name='Rufus', data={
...     'breed': 'labrador',
...     'owner': {
...         'name': 'Bob',
...         'other_pets': [{
...             'name': 'Fishy',
...         }],
...     },
... })
>>> Dog.objects.create(name='Meg', data={'breed': 'collie', 'owner': None})

>>> Dog.objects.filter(data__breed='collie')
<QuerySet [<Dog: Meg>]>

>>> Dog.objects.filter(data__owner__name='Bob')
<QuerySet [<Dog: Rufus>]>

>>> Dog.objects.filter(data__owner__other_pets__0__name='Fishy')
<QuerySet [<Dog: Rufus>]>

Source: stackoverflow.com

Similar codes

0 vote189 views1 answer
Lowercase all text in a column
Python
33 votes184 views2 answers
Python b to string
Python
1 vote219 views1 answer
An array of dates python
Python
0 vote233 views1 answer
Drop nulll python
Python
4 votes194 views2 answers
Loginrequiredmixin
Python
0 vote176 views1 answer
Conditional Statements to Skip Items enumerate python
Python
10 votes162 views4 answers
Count values pandas
Python
0 vote204 views1 answer
Extrapolate python
Python
48 votes170 views2 answers
Python regex tester
Python
1 vote172 views1 answer
Export PyTorch model in the ONNX Runtime format
Python