Each of my client have a database with the same structure, so I would like to create only one question and set the question database dynamically. I will use the as embed question in my website,
I have tried to use the locked parameters as show bellow, but it didn't work.
Does anyone have a solution for this?
SELECT auth_user.username AS username
FROM {{mydatabase}}.auth_user
WHERE id = {{user_id}}
LIMIT 2000;
Hi,
Like the poster, we have SQL queries which we run against different databases, one database for each environment.
Is there a filter to select the database to be used?
I guess questions could be written against one of the databases e.g. the prod and then switch out the database to be used with the filter.
We don’t want to have to create the same question multiple times for each environment.
