Ragib01 opened a new issue, #23069:
URL: https://github.com/apache/superset/issues/23069
My SQL query is
```sql
SELECT count(ce.id)
FROM course_enrollments ce
LEFT JOIN course_batches as cb ON cb.id = ce.course_batch_id
WHERE cb.bn_title IN ('title1') AND ce.course_completeness=100.00
AND ce.created_at between '2021-7-01' AND '2022-3-14'
````
I updated this query for filtering like
```sql
SELECT count(ce.id)
FROM course_enrollments ce
LEFT JOIN course_batches as cb ON cb.id = ce.course_batch_id
WHERE cb.bn_title IN {{ filter_values('title')|where_in }} AND
ce.course_completeness=100.00
AND ce.created_at between '2021-7-01' AND '2022-3-14'
```
But getting an error like this
```
Unexpected error
Error: (1064, "You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '{{
filter_values('title')|where_in }}\n AND ce.course_completeness=100.00\n
' at line 6")
```
Syntax **{{ filter_values() }}** is not working in my apache superset. How
can I solve this?
I am using mysql database and connected it to apache superset.
--
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]
