search

jfinkels / flask-restless

NO LONGER MAINTAINED - A Flask extension for creating simple ReSTful JSON APIs from SQLAlchemy models.
https://flask-restless.readthedocs.io
GNU Affero General Public License v3.0
1.02k stars 301 forks source link

How to run a Flask-restless api filter query on JSONB content #623

Open artagel opened 7 years ago

artagel commented 7 years ago

I there a way to run a filter query on a JSONB column? I can't seem to find a way to do this natively. I'm thinking I will need to modify the query generator to properly handle the query if I create the search param with a ->> inside.

See http://stackoverflow.com/questions/41385406/how-to-run-a-flask-restless-api-filter-query-on-jsonb-content for details.

jfinkels commented 7 years ago

I haven't tested this or attempted to provide support for filtering on JSONB columns yet. But this might be a nice addition. A unit test would go in tests/test_filtering_postgresql.py.

niroberson commented 6 years ago

bump