Text dropdown list filter based on another question is not working


I'm trying to implement a dropdown filter based on the results of another question (in this case I can't use field filters, so I'm using a text filter with dropdown option).

I created the question that the filter is based, and it is working fine. But when I configure it in dropdown list filter, metabase says that there is an error in my query.

Does anyone knows how to fix it?

Can you share the troubleshooting info for your version of Metabase? Also, what database is the query being executed against?

My metabase is running on "java.version": "11.0.23" and it is a mysql database

Thank you. Could you go to Admin Settings -> Troubleshooting and share the "Diagnostic Info" please?