Hi,
I am using external database(SQL Server) for my web app.
I am using OS User table(Internal Database). I am storing outsystems user id in my database.
On the screen preparation i am aware that we can't join Internal and external database.
Since i am storing only user id in external database, what is best way to display user details(like name) ?
Depends, you can create a function with input-parameter UserId which returns the fullname.
make sure the cache is set.
There is a performance-penalty on thise when you are calling this function plenty of times on the screen.