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.
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-
Pramod Jain wrote:
Is that true?Let us say you have a User table in SystemDB and AvailableFeatures table in FeaturesDB. When I try to join these two tables in an aggregate, I get a "Invalid Aggregate: Aggregate cannot join data from multiple databases. Change it to only use entities from a single database." message.Ravi
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
Hi Marcelo,
May you instruct me what the catalog of the external table is?
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."
Thanks it works for me