How to display group name instead of sys_id

Brandon R1
Tera Contributor

I'm using a Lookup Select Box variable for a 2nd approval in my catalog item. This variable is referencing the sys_user_group table and I have a reference qualifier specifying the 3 groups to be referenced for the drop-down selection in the variable on the form.

find_real_file.png

In order for the workflow to stop (instead of automatically skip) at this "Approval - Group" activity, the lookup value field for the variable has to be the Sys_ID instead of Name. For the Lookup Select Box field on the form, I need it to display the group names NOT the Sys_IDs.

find_real_file.png

I think the best way to achieve this is to use a Catalog Client Script but I'm unsure of how it should be written. Can someone help me with this??

Thanks,
Brandon

 

1 ACCEPTED SOLUTION

Hitoshi Ozawa
Giga Sage
Giga Sage

Instead of using Lookup Select Box, how about using Reference type? Reference type will enable to  display Name field and still use sys_id.

View solution in original post

11 REPLIES 11

abhijitkhewale
Mega Expert

Lookup value field should be name in your selection.

Dan Ellis
Kilo Sage
You can set the "lookup label field" field to be "Name".

I had tried this but it broke the workflow.

Hitoshi Ozawa
Giga Sage
Giga Sage

Instead of using Lookup Select Box, how about using Reference type? Reference type will enable to  display Name field and still use sys_id.