When using sql sqllab, how to add a filter box for non-display fields to filter

[zsw4579]

select
a,b,c
from t
where d = 'xxx' and
{% if appid %}
appid in ({{ "'" + "','".join(filter_values('appid')) + "'" }}))
{% else %}

{% endif %}

Example above,please tell me how to solve it.
how to add a filter box for non-display fields (such as appid)?
In version 4.0.2, I could not create a filter box for the appid field

[dosubot[bot]]

In Apache Superset version 4.0.2, the Filter Box feature was removed, and existing filter boxes are automatically migrated to native dashboard filters ^[1]. This means you can no longer create filter boxes as you did before.

To filter non-display fields like appid in SQL Lab, you can use Jinja templating with the filter_values function. This function allows you to retrieve filter values as a list and apply them in your SQL query. Here's an example of how you can use it:

SELECT a, b, c
FROM t
WHERE d = 'xxx'
{% if appid %}
  AND appid IN ({{ "'" + "','".join(filter_values('appid')) + "'" }})
{% endif %}

This approach uses Jinja's conditional logic to include the appid filter only if it is present. The filter_values function retrieves the values for the appid filter, allowing you to apply it to non-display fields ^[2].

To continue talking to Dosu, mention @dosu.

---

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

[zsw4579]

@dosu
However, when I create a filter box, I can only add a filter box for the displayed result field, and cannot create a filter box for non-result fields

[dosubot[bot]]

In Apache Superset version 4.0.2, the Filter Box feature has been removed, and you can no longer create filter boxes for non-display fields as you did before. Instead, you should use native dashboard filters, which are the new standard for filtering in Superset. However, native dashboard filters also primarily work with fields that are part of the displayed result set.

To filter non-display fields, you can use Jinja templating in SQL Lab with the filter_values function, as previously mentioned. This allows you to apply filters to fields that are not directly displayed in the result set by incorporating them into your SQL query logic. Unfortunately, there isn't a direct way to create a filter for non-display fields in the dashboard interface itself.

To continue talking to Dosu, mention @dosu.

---

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