How to Join fields from two separate databases?

[baub]

Ok I’ve got two separate databases. One has orders and is the public facing website and the other is the internal production/Fabrication server. I need to query job status from the fabrication server and then find out which of the orders on the website those are? If the data was on a single database that would be a simple join. But I can’t join in wappler from two separate databases, although I have no problem accessing both databases from the server action scripts.

I’m guessing I…
step 1, query fabrication server for statuses
step 2, add a repeat to that action
step 3, somehow I match the orders from the webserver to match step 1?

Any direction would be great!

@teodor

[mebeingken]

Maybe this helps…

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 use…

[baub]

thanks @mebeingken ! I’ll give that logic a spin, I knew it was something similar to that?

[mgaussie]

This is excellent @mebeingken. Are you using a condition to match the values together?

[baub]

I kind of had to do the whole thing in reverse. I had to query production with values for workcenter and where it was in the order progress (i only needed orders that were in the first stage of production). Then I queried the orders and found which ones were active. But there were too many results as the workcenter could be multiple values and multiples stages in production. So i grabbed all the data even including the extra stuff, and then filtered them through a dataview on the the client side. When I get time I’ll show some screen shots.

[Teodor]

You can now join data sources from different databases:

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

[baub]

Cool! This is AWESOME!!!