Query results from another database

Wappler General How To
#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

#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.

#3

Ok that helps! Thanks

1 Like
#4

It’s possible using the server side data transformations as explained here:

1 Like