How to search list simple objects column?

[alexri]

I have a data table with one column called Tags which is a list of strings like [‘DataBase’,‘Big Data’]. I am trying to search like this app_tables.mydatatable.search(Tags=taglist) where taglist = [‘Big Data’]. However it does not return anything. Strangely if I search like app_tables.mydatatable.search(Tags=[‘Big Data’]) it returns the correct rows.

[stucork]

related post:

Query to test for equality of simple objects

As referenced here, I would find it useful to be able to test for the strict equality of simple objects within a DataTables query. Currently, when you query a simple object column, it matches on subsets. For example: # a simple object in a DataTable {"foo":[1,2,3]} This query will match the above simple object: app_tables.my_table.get(simple_obj={"foo":[1,2]}) This query will not: app_tables.my_table.get(simple_obj={"foo":[1,2,3,4]}) If you have two similar simple objects in your DataTabl…

[alexri]

Yes , searching a simple object column with list values works exactly as mentioned in the docs. It was my mistake , I was modifying the list in my code.