hasura / hasura/graphql-engine
Support to use _ilike in a json or jsonb object
Open
k/enhancement
t/native-dbs
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
### Is your proposal related to a problem?
I have a table "tableName" wich has a column "metadata" wich is a jsonb object.
I'm trying to filter "tableName" rows by metadata.object.filedName using the operator "_ilike" but it's not possible to use the "_ilike" operator in a jsonb object.
### Describe the solution you'd like
It would be very helpful to have te hability to use sql operators such as "_ilike" to search for values in a jsonb object.
Contributor guide
Research direction
The issue names no files or tests. Start by locating the PostgreSQL JSONB filtering path and existing _ilike handling; done means _ilike can filter values at metadata.object.filedName.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgres
- Domain
- api, databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100