Look up select box variable in service catalog

[Prateek Tyagi2]

I have look up select box variable taking reference from user table and lookup value field is user ID. when I search from user ID I am able to search the user. But when I enter name or email of user then I am unable to search the user.

Is there any way so that I can search on the basis of other fields. Only want to display user id in field.

Thanks

[Amit Gujarathi]

HI @Prateek Tyagi2 ,
I trust you are doing great.

Here's a solution that allows searching by name or email while displaying only the user ID in the field:

1. Edit the existing lookup select box variable.

2. Navigate to the variable's form or open the related catalog item.

3. Locate the lookup select box variable you want to modify.

4. Edit the variable and modify the following properties:

   • Set the "Lookup" field to the "sys_user" table, which contains user records.
   • In the "Search Fields" field, add the fields you want to search on. For example, "name,email".
   • Set the "Return Field" to "sys_id", which represents the user ID.

5. Save the changes to the variable.

[Prateek Tyagi2]

Hi @Amit Gujarathi 

Can you please guide me where are the fields you have mentioned above I couldn't find any search and return fields.