Open vijayprasanna13 opened 5 months ago
@vijayprasanna13 @SamirTalwar Any updates on this? whether it will come in future or cant be done?
Hey @anish-pr, thanks for pinging me.
Currently, we don't support this kind of composition over JSONB columns, and doing so would require a significant modification to our GraphQL syntax and schema. There are no plans to make changes to this in Hasura v2. We plan on providing much greater support for JSONB columns with v3, but it won't be in the first batch of functionality.
We suggest you use one of two features to accomplish this.
Hopefully one of those suits your needs!
@SamirTalwar @vijayprasanna13 any updates on this? when can we expect this? we have a growing need for filtering based on JSONB column values like greater than, less than, equals, etc. We use Hasura extensively for all our workflows, and sometimes because of the nature of the data, it is schemaless too. This would help us.
Description
Currently, the documentation for JSONB column operators has support for only
_contains
,_contained_in
,_has_key
,_has_keys_any
and_has_keys_all
. However, in PostgreSQL, we can execute queries using operators such as >, <, =, among others, as illustrated in the example below:The documented operators might not suffice for operations like >, <, =, and similar comparisons.