Getting sys_user information from sys_user_grmember

[Patrick Maxwell]

I have a reference to the 'sys_user_grmember' table inside of a catalog item which only allows selections from members in a certain group. When a user is selected I need to get that user's name and phone number but can't figure out how to do that since the phone number is not stored in this table. I also don't think the user's SID is in this table so can't query the sys_user table using that. Does anyone have a way to do this?

[Saurabh Gupta]

Hi @Patrick Maxwell 
Where do you need these phone number and name?

[Patrick Maxwell]

I'm trying to get the information from sys_user using the sys_user_grmember to auto populate the phone number field in the catalog item

[Saurabh Gupta]

Hi @Patrick Maxwell ,
There is OOTB feature to auto populate the variable based on the other variable.

You can use that feature.

[Patrick Maxwell]

I don't think that would work for me because I'm trying to get information that is not stored in the table I'm referencing. Is there a way to get the sys_id of the user in the sys_user table from the sys_id of the user in the sys_user_grmember table? If there is a way to do that then I guess I can just query using the sys_id and get it done like that. Thanks