Join users with external database


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.