id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
29112	Make it easier to update specific keys within nested Django JSONField data.	Michael		"Django's docs have a great example of querying nested data using double underscore syntax similar to querying across foreign keys


{{{
Dog.objects.filter(data__owner__name='Bob')
}}}

What if we wanted to update this dogs owner's name instead (without touching anything else)? Rather than doing this


{{{
dog = Dog.objects.get(pk=n)
data = dog.data
data['owner']['name'] = 'Steve'
dog.data = data
dog.save()
}}}

It would be great to do this:


{{{
Dog.objects.filter(pk=2).update(data__owner__name='Steve')
}}}


Looks like django-postgres-extensions[0] attempts to do this, but I found the library to be unstable on 1.11.


[0] - http://django-postgres-extensions.readthedocs.io/


"	New feature	closed	Database layer (models, ORM)	dev	Normal	duplicate		Tom Forbes	Accepted	1	0	0	1	0	0