django - How to use keyTextTransform() for nested json?

Question

My model has a json field. I can access jsonfield['key1'] with the following query

from django.contrib.postgres.fields.jsonb import KeyTextTransform
MyModel.objects.annotate(val=KeyTextTransform('key1', 'jsonfield')).order_by('val')

But how can I access a key like jsonfield['key1']['key2'] or even more nested ones?

This can't be the only solution, right?

MyModel.objects.annotate(val=KeyTextTransform('key2', (KeyTextTransform('key1', 'jsonfield'))).order_by('val')

question from:https://stackoverflow.com/questions/65921227/how-to-use-keytexttransform-for-nested-json

Answer 1

Waitting for answers