537
Views
6
Comments
join of internal and external database tables
Question

Hi,

I am an Outsystems beginner. I am able to connect to my external database without any problem, but how do I join an internal Entity (User) with an external one (which has the logical database field in the advanced tab filled). I tried to join with an Aggregate and with an SQL, no success. If joining internal and external entities is not possible, what is the most efficient way to show results in the UI that combine the data from the two tables?

Thanks,


Denis.

mvp_badge
MVP
Rank: #51

HI Denis,
Welcome to the community :)

You can see the executed query from outsystems Test query and check what query is being created in the background . Yo can also try to execute that query from any client tool and can see what exactly the issue is .

As per my knowledge Sql Server support join in two different database if they are on the same server.


Regards

-PJ-

mvp_badge
MVP
Rank: #15

Hi Ravi,

even if both DB are in the same server you need to user advance query to access it instead of Aggregate. Keep in mind you need to use the catalog and schema name to reference the tables of the external table.

Btw when you see this really old posts is always better to create a new post with your question and if needed reference the old one with a link

Regards,

Marcelo

Rank: #896

Hi Marcelo, 

May you instruct me what the catalog of the external table is?

Rank: #1281

Join tables from different databases is not possible.

What i did is...

"Take Aggregate of different databases separately and get the output by adding filter in corresponding aggregate."

1.png