Another way to query JSONField in postgresql django

Question

I have made Django project with the database on PostgreSQL. I have one column data which is a JSONField() object. Now for querying in the data JSON blob, the docs show only one way. Say some rows have the key as 'Salary' in data so according to docs if I want to retrieve the row with salary as something then the way is:

TableName.objects.filter(data__Salary__gte = 15000)

Now the problem is that I want to make it user specific like the user will tell the key and pass it to the function and I want something like this:

keyValue = 'Salary'
TableName.objects.filter(data__keyValue__gte = 15000)

But this does not work for obvious reasons as there is no column of keyValue in data. Is there any other way of doing it?

possibly duplicate of this.

Vikas Periyadath
– Vikas Periyadath

2018-01-18 12:07:09 +00:00
Commented Jan 18, 2018 at 12:07 — Vikas Periyadath
– Vikas Periyadath, Commented Jan 18, 2018 at 12:07

user459872 · Accepted Answer · 2023-10-11 05:43:52Z

2

You can create a dictionary and unpack it in the filter call using the ** operator.

>>> key_value = 'Salary'
>>>
>>> params = {'data__%s__gte' % key_value:15000}
>>> TableName.objects.filter(**params)

edited Oct 11, 2023 at 5:43

answered Jan 18, 2018 at 12:03

user459872

25.9k4 gold badges51 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

Another way to query JSONField in postgresql django

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related