JacoDeB
Rookie

K2SQL User Display Name

Hi

 

I'm busy building a solution that needs to provide one set of forms for internal users, and a subset of the forms for external users. I've set up a secondary runtime site, and configured it to use the FormSTS with K2SQL.

I also built forms that allows users to add and configure users to the CustomUM tables in the K2 database, with a display name, email address, manager.

 

Now that I've started to try and use the forms on the secondary site, I ran into a problem that I can't find information on from searching.

The user logs in, but none of the properties such as the user name, display name etc that was filled in on the CustomUM table are available.

To demonstrate, this is the row in the table:

TableRow.png

I created a small view that transfers the data from the user info to text boxes. This is what it shows for my internal user:

JacoDeB_1-1634121194198.png

But for the K2SQL user, only the FQN is pulling through:

JacoDeB_2-1634121276051.png

Is there a way to get the user's info to pull through? I had to trigger a Sync Service run to be able to login at all, but the values in the SyncEngine.Identity table looks correct as well

JacoDeB_3-1634122038416.png

 

 

Labels: (1)
0 Kudos
Reply
2 Replies
khanh
Nintex Employee
Nintex Employee

Re: K2SQL User Display Name

Hi JacoDeB,

 

I have an old environment with SQLUM setup (non domain setup) and I'm seeing similar behavior. I don't think it's related to secondary Smartforms site setup in your scenario. Perhaps, another approach is to UMUser SmartObject call (i.e. Execute SmartObject method action), you can pass in the FQN (K2SQL:johnSomething) and get the return display name, etc. 

0 Kudos
Reply
JacoDeB
Rookie

Re: K2SQL User Display Name

Thanks khanh. I thought I might have to do that, but it's annoying.

0 Kudos
Reply