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.
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 for the output, and I select the output fields. Within the repeat, job_name goes to the remote database and gets another value I need, and by setting a value in the repeat, it is adjoined with the other fields, as if it had been in the original query.
In the end, you get the same type of output: