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!