Mapping sysid

[Ramya SL]

I have created a reference variable in sc_request table as u_user_id
How to map sys_id of u_user_id to sys_id of user_name of sc_user list through script

How to get sys_id of variable names

[Mark Manders]

If you reference your variable to the user table, you have the data in your variables. No need to script that.

And every variable has it's own sysid after it's created. You can just use right click - show sysid.

[Ramya SL]

Yes but I need to map sys_id of my catalog item variable(user_id)  to the user_name field of sys_user table.

[Mark Manders]

Please elaborate on your requirement. What are you trying to do? What requirement are you trying to fulfill? Do you need to get the user on the form? Do you need to fill a field with a user?

[SunilKumar_P]

Hi @Ramya SL , from the sentence 'I have created a reference variable in sc_request table as u_user_id', do you mean you have created a variable of reference tye in catalog item? or a field of reference type in sc_request (REQ) table?

and do you want to map the sys_id of this reference variable to 'user_name' (Label User ID) on sys_user table? 

Regards,

Sunil