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

8 votes279 views2 answers
Python print combinations of string
Python
0 vote246 views1 answer
Create and add many to many field in django
Python Django
74 votes257 views1 answer
How to update pip in anaconda prompt
Python
60 votes248 views6 answers
Python remove duplicates from list
Python
8 votes306 views2 answers
Python add a string to a list
Python
0 vote611 views1 answer
Audioplayer python
Python
0 vote307 views1 answer
Cannot access modules from neighbouring directories jupyter notebook
Python
0 vote270 views1 answer
How to play mp3 audio in python
Python
1 vote271 views2 answers
Rightclick in pygame
Python
3 votes286 views4 answers
Seaborn correlation
Python