Filtering on ListColumn should allows 'contains'

[Simon-Le]

When one of the fields is a ListColumn of strings for example, filtering on this field requires an exact match of the entire list.

Shouldn't be possible to filter on one or multiple items of the list.

Example:
[{'A': ['x','y','z']},{'A':['x']}]

When the filter ?A=x is provided both items should be returned.
When the filter ?A=x&A=y is provided only first item is returned.

Current behavior to get the first item ?A=x&A=y&A=z should be provided

[Colin-b]

You're talking about Mongo ListColumn ? It we can foresee an option to allow partial list equality for matching. I guess the order would not matter in this case ?

[Simon-Le]

Yes for MongoDB ListColumn, and yes order isn't important.

[Simon-Le]

{ $all: [ 'x', 'y' ] } allows this