Join between 2 tables of 2 different databases

[Djibril]

Hi,
With Wappler, is it possible to join 2 tables from 2 different DB? The DB are on the same server.
Thx

[Dave]

Yes you can simply add the second database as another database connection and select it in your Server Actions. This allows you to connect as many databases on as many hosts as you wish.

[Djibril]

But, for a query we can select only one database connection

[George]

after executing the two queries separately, you can create a new output object by looping trough the records of the one query and adding the data of the second one.

So actually you are making your own join.

[JonL]

Check this.

Two data sources, one output

Up to this point, my projects have had a single datasource, so querying with joins makes returning a single dataset straightforward. But what to do when you have two datasources where joins are not possible? Wappler makes it easy by using the repeat action and clever output options. [20%20AM] The two datasources: ‘hc’ is mysql, and ‘hcinternal’ is mssql on a remote server. query_job_orders gets the baseline information but I don’t output the query itself as I normally do. A repeat is used…

[Dave]

But, for a query we can select only one database connection

Carry the identifying variable across in a post, cookie, or session, for example. Add your second DB Connection and set up your second DB query and action below the initial query to the first DB, then use the variable to filter the second DB query as you did the first but using the second DBs connection and the same filter variable passed earlier…

[Djibril]

Thx, I will check and revert

[Teodor]

Now that’s possible:

Join Results of 2 Data Collections

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 database connections. Data Transformation We have two database queries using two different database connections, so we can’t join them using the query builder.…

[Teodor]

That’s already possible using the Server Connect Array List component:

Working with Server Connect Array Lists

Intro The Server Connect Array List component allows you create and manipulate Array Lists easily with Server Connect actions. You can add items to an array, join multiple sources, remove and set arbitrary items, keep simple or complex objects or collections in an Array List. It’s also easy to use it as a string builder, when you need multi lines strings. Basics In order to be able to add items to an array you first need to define the array. The Array List actions are located in the Data Man…