Join users with external database

Join users with external database

  

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) ?


Solution

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.

Solution