id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 27257,Use the ->> operator when filtering builtin text lookups on JSONField keys,Nick Stefan,Simon Charette,"Given a model with a jsonb field, 'content', and it has a key called 'altText'. {{{ queryset.filter(content__altText__iregex=""bob"") }}} creates this SQL {{{ ""content"" -> 'altText'::text ~* 'bob' }}} Which creates a type error {{{ ERROR: operator does not exist: jsonb ~* unknown at character 2792 postgres | HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. }}} SQL actually needed is {{{ content ->> altText ~* 'bob' }}} So I had to use: {{{ queryset.extra(where=['content ->> %s ~* %s'], params=['altText', 'bob']) }}} Is this something to be filed under QuerySet.extra or is this more of a bug just with JSONField ? ",Bug,closed,contrib.postgres,dev,Normal,fixed,,,Ready for checkin,1,0,0,0,0,0