Hi, I have 3 entities ExpenseReport, Expense, ExpenseReportStatus taken from the external Database i.e Azure Sql server. I need to give relationship for all these entities but unable to give the relationship.
How to give relationship like this given the below diagram?
Do you mean that these relations are not already created in the tables in the external database? Cause if that is your problem this is not something you can add via OutSystems.
What you could do is create some entities in the OutSystems database that will bind these entities together but this will come with a huge performance and memory footprint because you can't join over separate databases. This is not a OutSystems limitation but a SQL limitation.
Hi Annie,
You can create outsystems entity for establishing relationships between them.
For ex create entity - "ExpenseRelations"
Attribute will be:
ExpenseReportId
ExpenseId
ExpenseReportStatusId
But as Vincent said this will come with a huge performance and memory footprint.
Regards,
Arun