Superset filtering for substrings

[reshmanov21]

How can I filter by a substring match on a superset dashboard? For example, let's say the values of a Team Name column is "team-blr-1", "team-blr-2", "team-del-1". I want to search for all values that match "blr" (Similar to LIKE in sql), instead of an exact string match.

[dosubot[bot]]

Hey @reshmanov21 👋, I'm here to assist you with any bugs, questions, or contributions. Let's tackle this together!

To filter by a substring match on a Superset dashboard, similar to using LIKE in SQL, you can use the LIKE or ILIKE filter operators. These operators allow you to perform pattern matching on string columns.

For your specific case, to find all values that match "blr" in a "Team Name" column, you can use the ILIKE operator for a case-insensitive match or LIKE for a case-sensitive match. Here is how you can set it up:

{
    "col": "Team Name",
    "op": "ILIKE",
    "val": "%blr%"
}

This filter configuration will match any "Team Name" that contains the substring "blr". The % symbols are used as wildcards to match any sequence of characters before and after "blr" ^[1].

To continue talking to Dosu, mention @dosu.

[reshmanov21]

@dosu I understand that this feature exists at the chart level filtering. But at a dashboard level, I am unable to search for a substring. Even if I do, I will have to select the results one by one manually from the filter results dropdown. Is there a way to select all on a substring search at a dashboard level?

[dosubot[bot]]

Currently, there isn't a built-in feature in Superset to programmatically select all filter results at the dashboard level when using a substring search. You would need to manually select each result from the filter dropdown. However, you can customize the filter dropdown to support substring searches by using the ILIKE operator, as mentioned earlier. Unfortunately, selecting all results automatically isn't supported at this time.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}