Hi, I am calling my ExpenseReport entity from the external Database and for the User info related data I am using the Outsystem DB. For the SubmittedBy, FirstApprover, FinalApprover, CreatedBy attributes, I need to set it as Foreign Key of the User Identifier. How to set the DataType as UserIdentifier for the SubmittedBy attritube? I am unable to do any aggregation. Should need to create a User Entity in External DB too? If I create a similar external System Entities that outsystem provides, is it possible to create?
How to give the external DB attribute datatype as outsystem's user Identifier?
Hello,
I'm not understanding the question. The screenshot you put shows exactly how to put SubmittedBy as a User Identifier... Nothing else is needed.
Hi @Nuno Magalhães,
In the External DB, for the SubmittedBy attribute its Data Type is integer. I need to give its data type as User Id. I have updated the screenshots above.ThanksAnnie
Hi Annie,
See my reply on the same question asked in 2020, that was marked as solution:
https://www.outsystems.com/forums/discussion/61543/how-to-join-internal-user-entity-and-external-database-in-advanced-sql/
Regards,
Daniel
Hi @Daniel Kuhlmann, I have gone through that forum. Can you please explain in more detail. Thanks,Annie
You can have user_extended entity in External DB, and you can include that Key(user_extended_id) in User entity(Outsystem entity),Column (external_Id).
But you cant join the outsystem entity and external DB entity.