unable to make sql query with coder: JSON and psql

[GuillaumeM59]

Hi,
I tried to execute sql query with postgresql on my typed store column but nothing return.
I'm looking to make scopes and sql queries using settings.

I have two users with 'foo' settings set to true.
User.where('("settings"-->>'foo')::boolean IS TRUE').size #=> 0 instead 2

You can find exemple with rspec test here:
https://github.com/GuillaumeM59/typed_store_sql_query

it's look like postgresql jsonb data is over stringified ...

thanks

[borisrorsvort]

@GuillaumeM59 Have you tried with the coder: ActiveRecord::TypedStore::IdentityCoder ?