Jinja filter defined in DataSource not considered in "Explore Chart"

[lilila]

A clear and concise description of what the bug is.

Expected results

I have defined filters in the definition of the data source using jinja template

For instance:
{% set title_target = ' "' + filter_values('title_target', 'Joker' )[0] + '" ' %}

title_target is not a field of the data source itself. I use this variable to generate "readable" subqueries.

{% set title_target_id = ' (SELECT id FROM film_id WHERE title = ' + title_target + ' ORDER BY release_date DESC LIMIT 1)' %}

Which allows me to write my datasource as :

SELECT 
	a,b,c
FROM
	`view_films`
WHERE film_id = {{title_target_allocineid}} and title_comp <> {{ title_target }}

Actual results

This logic works very well in the context of dashboard. However if I click on "Explore Chart" for a chart based on this datasource the chart always displays data for 'Joker' which is the default value (as we set title_target = ' "' + filter_values('title_target', 'Joker' )[0] ) even if the filter "title_target" is set up.

How do I get "explore chart" view to load filter_values ?

Screenshots

You can see on this plot the title_target filter set to "Miss" and the result shows "Joker" the default "filter_value"

Environment

(please complete the following information):

• superset version: superset 0.36.0.rc1

[villebro]

Thanks for the detailed issue @lilila , I will investigate this.

[lilila]

Thank you for the fix