GitHub user dosubot[bot] added a comment to the discussion: Jinja template 
filter_values not working/not showing

<!-- Greeting -->
Hello @paridbushati! I'm [Dosu](https://dosu.dev), a friendly bot here to help 
you solve bugs, answer questions, and guide you toward contributing. I'm ready 
to assist you while you wait for a human maintainer. Let's tackle this issue 
together!

<!-- Answer -->
I found a similar discussion that might help you resolve the issue with 
`filter_values` in your Jinja template. In the [Dynamic SQL 
query](https://github.com/apache/superset/discussions/31722#discussioncomment-11747281)
 thread, it was suggested to ensure that Jinja templating is enabled in your 
`superset_config.py` by setting the `ENABLE_TEMPLATE_PROCESSING` feature flag. 
Since you've already confirmed that template processing is enabled, here are a 
few additional steps you can take:

1. **Check Filter Configuration**: Ensure that the filter names used in 
`filter_values('column1')`, `filter_values('column_date')`, and 
`filter_values('column2')` match exactly with the filter components' names in 
your dashboard.

2. **Dashboard Filter Application**: Verify that the filters are correctly 
applied to the virtual dataset in the dashboard. Sometimes, filters might be 
applied at the dashboard level rather than within the SQL query, which could 
explain why the template doesn't show up in the query.

3. **Debugging**: You can add debug statements in your SQL query to print out 
the values of `filter_values` to ensure they are being captured correctly. For 
example, you can use `{{ filter_values('column1') }}` to see what values are 
being passed.

If these steps don't resolve the issue, consider reviewing the filter 
configuration in your dashboard to ensure it aligns with the query logic.


<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*

---
<sup>Help Dosu learn! Give it feedback: [Great 
Response](https://app.dosu.dev/response-feedback/5189d458-8e4e-4867-944d-fd07b871b4b8?feedback_type=great_response)
 | [Irrelevant 
Answer](https://app.dosu.dev/response-feedback/5189d458-8e4e-4867-944d-fd07b871b4b8?feedback_type=irrelevant_answer)
 | [Incorrect 
Sources](https://app.dosu.dev/response-feedback/5189d458-8e4e-4867-944d-fd07b871b4b8?feedback_type=incorrect_sources)
 | [Too 
Verbose](https://app.dosu.dev/response-feedback/5189d458-8e4e-4867-944d-fd07b871b4b8?feedback_type=too_verbose)
 | 
[Hallucination](https://app.dosu.dev/response-feedback/5189d458-8e4e-4867-944d-fd07b871b4b8?feedback_type=hallucination)
 | [Bug 
Report](https://app.dosu.dev/response-feedback/5189d458-8e4e-4867-944d-fd07b871b4b8?feedback_type=bug_report)
 | 
[Other](https://app.dosu.dev/response-feedback/5189d458-8e4e-4867-944d-fd07b871b4b8?feedback_type=other)</sup>


GitHub link: 
https://github.com/apache/superset/discussions/33086#discussioncomment-12791362

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: 
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to