rokit
January 12, 2023, 6:39pm
1
I have a table in my “employee” database that allows me to pick the “vehicles” from another database
I would like to show the details of the vehicles in my table but I cannot query from 2 different databases.
How do I show the details of my vehicles based on the units returned in my employee query
brad
January 12, 2023, 6:46pm
2
I’ve only been able to do that by creating a ‘view’ in Navicat. The view is then accessible in the database manager. I don’t think Wappler has a way to create a view yet. If there is a Wappler way to do it, I’d like to know as well.
Teodor
January 12, 2023, 6:55pm
4
It’s possible using the server side data transformations as explained here:
Intro
Using the Data Transformations options you can easily join the results of two different data sources such as - a database query and an API response, the results of 2 database queries from 2 different databases, or any other array data.
In our example we will show you how to join the results of 2 database queries from 2 different databases.
Data Transformation
We have two database queries using two different database connections, so we can’t join them using the query builder. We can joi…
1 Like