It's just a simple syntax issue in Boncheff's query. in_ takes a list so it should be:
*session.query(MyModel).filter(MyModel.foo[0]['tags'].in_(['test_tag1'])).all()* On Tuesday, November 27, 2018 at 11:55:57 AM UTC-8 himanshu jain wrote: > How did you get it working? > can you give an example please > > > On Thursday, March 17, 2016 at 6:44:42 AM UTC-7, Boncheff wrote: >> >> Thanks for your replies - it is now working as expected >> >> On Tuesday, 15 March 2016 16:50:58 UTC, Boncheff wrote: >>> >>> We have a DB model that contains a 'foo' field which is JSONType >>> >>> Inside this we store the following data: >>> >>> foo => [{"apps": ["test_app"]}, {"tags": ["test_tag1", "test_tag2"]}] >>> >>> My question is, how can I, using session.query, select all items that >>> have a *test_tag_1* as a tag inside the foo column? >>> >>> I tried* >>> session.query(MyModel).filter(MyModel.foo[0]['tags'].in_('test_tag1')).all()* >>> >>> but this results in >>> >>> *** NotImplementedError: Operator 'getitem' is not supported on this >>> expression >>> >>> Is what I am trying to achieve even possible? >>> >> -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/44285d8e-1a1f-4722-b946-31c904b0c0d4n%40googlegroups.com.