Put filters in an array instead of filters on strings only on Dashboard

[shrutimkrishnan]

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if any
• I have reproduced the issue with at least the latest released version of superset
• I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

0.19.0

Expected results

Want the ability to filter the dashboard with an array rather than string values only. Example:

Actual results

Only able to filter based on set string values

Steps to reproduce

As shown above

[mistercrunch]

You can probably write a WHERE clause that would do that can't you?

[shrutimkrishnan]

@mistercrunch Need to give the user the ability to filter A1 or A2 on their own from the filter slice... Otherwise we end up having to duplicate rows of data to both A1 and A2 just to make it work with a defined string.

Sent from my Google Pixel using FastHub

[mistercrunch]

there's a like option in the dropdown, what about picking that and writing %A1%?

[shrutimkrishnan]

@mistercrunch Gives an error message - 'dict' object does not support indexing

[mistercrunch]

Notice: this issue has been closed because it has been inactive for 254 days. Feel free to comment and request for this issue to be reopened.

[applechip]

Any chance this issue can be reopened? I know there is a workaround using Jinja templating but that is inconvenient.

[matheusbsilva]

UP I'm facing the same issue on version 3.0.0. I can't filter a field of type string array by searching for a value inside of the array, I know I can write a custom SQL query to filter the chart but I can't do the same in dashboards. Is there any workaround for this?