I have a jsonb
column in my postgres
db is there a way to query records using filters for key values in that columns.
Table A
id
name
metadata
metadata
has active
and identifier
I can get record using name as such
<url>?page=1&page_size=3&order_by[]=name&order_directions[]=asc&filters[0][field]=name&filters[0][value]=DAT
how do I add metadata.active
or metadata.identifier
to my filters ?