How to query specific field in django JSON field

Question

I have a model, which has JSON field called data. I need to query all models, which have type in this data field, which starts with string gpa.

Corresponding query is:

select data ->> 'type' from model where data ->> 'type' like 'gpa.%'

How can I do this using querysets? All I could find is an exact match, not startswith. I am using django 1.18

kamilyrb · Accepted Answer · 2020-03-06 22:33:20Z

1

I assume that you have data jsonfield, and you are searching value of key named type starts with 'gpa.'.You can try this:

Model.objects.filter(data__type__startswith='gpa.')

edited Mar 6, 2020 at 22:33

answered Mar 6, 2020 at 15:30

kamilyrb

2,6273 gold badges13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to query specific field in django JSON field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related