Hi, I am working in a project where I need to consult data from more than one database (Postgres and MySQL). I am not using tags because I need to change the text of the queries dinamically, so I am writing the queries as text in some invisible labels, and making my charts execute those texts as SQL queries.
I have several connections defined in the gateway configuration (and they really work). The problem is that in the “Projects” menu I can choose the default database for the project, but I can choose only one. When I select the MySQL connection, the part that uses the PostgreSQL one stops working, and vice versa.
So, the question is: how can I use more than one defined database connection in my project? Is there some way to say the gateway to use more connections in a project than the default one? Thanks in advance.