xxcmp1977 commented on PR #6690:
URL: https://github.com/apache/superset/pull/6690#issuecomment-2275823735
I just found that it's ignoring unicode string prefix N when using where_in
clause in Jinja template
so that
`and path in {{filter_values('Category')|where_in}}`
expanded to
`and path in ('á é í ó ú ü ñ')`
instead of
`and path in (N'á é í ó ú ü ñ')`
Workaround is to manually rewrite it to something like
```
{% set values = filter_values('Category') %}
and path in (
{% for value in values %}
{{ "N'" + value + "'" }}{% if not loop.last %}, {% endif %}
{% endfor %}
)
```
I'm using mssql+pymssql connection
Superset version 2 (not sure whuch one exactly)
--
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]
