TheHassi opened a new issue, #23846:
URL: https://github.com/apache/superset/issues/23846
I want to use the Dashboard-Filters, but the column format is an array. For
this issue, I want to use JINJA templates.
The Flag is enabled: "ENABLE_TEMPLATE_PROCESSING": True
**The SQL Statement from the virtual dataset:**
`SELECT * FROM behandlungsdauer
{% if (filter_values('ix')|length) %}
WHERE ix @> '{{ ' {\"' + '\",\"' .join(filter_values('ix',
remove_filter=True)) + '\"}' }}'
{% else %}
{% endif %}`
**The Dashboard with Filters:**
**The SQL query, when filter applied:**
`SELECT # Something
FROM
(SELECT *
FROM behandlungsdauer
WHERE ix @> ' {"6"}') AS virtual_table
WHERE ix IN (6) #do not want this line as JINJA is already applied above
AND kohorte = 9
AND zeit NOT IN ('2. Jahr',
'3. Jahr',
'4. Jahr')
GROUP BY zeit
ORDER BY "KG (b1)" DESC
LIMIT 10000;`
What can I do to Solve this issue?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
