The issue I'm facing is similar to these tickets:
- Case insensitive lookups on JSONField nested values
https://code.djangoproject.com/ticket/27693
- Use the ->> operator when filtering builtin text lookups on JSONField
keys https://code.djangoproject.com/ticket/27257
- Document how to do a substring search in JSONField
https://code.djangoproject.com/ticket/26511
I have a JsonField in a model
data = JSONField(null=True, blank=True)
It contains this json:
{"name":"Hello"}
My filter is:
models.MyModel.objects.filter(data__name__icontains='el')
I expect the query to return the objects that have json where the "name"
contains 'el' (case-insensitive).
Instead, I get this:
ProgrammingError at /url/
> function upper(jsonb) does not exist LINE 1: ...
> UPPER("my_model"."data"...
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
The SQL that causes the error is
WHERE UPPER(("my_model"."data" -> 'name')::text) LIKE UPPER(%el%)
The working SQL is (note added quotes around LIKE text):
WHERE UPPER(("my_model"."data" -> 'name')::text) LIKE UPPER('%el%')
Is there a fix for this? Am I missing something?
Any help would be appreciated.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/a3921b9b-1fad-4600-952f-cb2ed5d1161d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
