Re: JsonField icontains filter generates invalid SQL

2017-04-10 Thread Simon Charette
Hello there, I'm not sure where you determined the SQL that caused the error but I'm pretty sure this was caused by "my_model"."data" -> 'name' not being wrapped in a parenthesis before the ::text cast. This has been fixed in Django 1.11[0]. Cheers, Simon [0] https://github.com/django/django/

JsonField icontains filter generates invalid SQL

2017-04-09 Thread cofiem
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