Django getting values from postgres JSON field

Question

I have a simple model like:

class MyModel(models.Model):
    data = JSONField()

The JSONField data is in the following structure:

{
  "name": "Brian",
  "skills": [
     {"id": 4, "name": "First aid"},
     {"id": 5, "name": "Second aid"}
  ]
}

I'd like to create a query that gets a list of MyModels filtered by the id of the skill inside the data.

I've tried a few different avenues here, and can do the work in Python but I'm pretty sure there's a way to do this in Django; I think my SQL isn't good enough to figure it out.

Cheers in advance.

Dharman · Accepted Answer · 2021-02-16 11:13:39Z

3

try this

>>> MyModel.objects.filter(data__skills__contains=[{'id':4}, {'id':5}])

more about JSON filter https://docs.djangoproject.com/en/3.1/topics/db/queries/#querying-jsonfield

edited Feb 16, 2021 at 11:13

Dharman♦

33.9k27 gold badges103 silver badges156 bronze badges

answered Feb 16, 2021 at 11:08

rahul.m

5,8363 gold badges29 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Django getting values from postgres JSON field

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related