Add user id to the reference type variable.

Ak8977
Tera Expert

There was field called hiring manager , it was refering to user table. while submitting the request it shows user name and email. But I want to see the user id along with them.
The following is the screenshot. could anyone help me how I can achieve it.
thanks,

4 REPLIES 4

Dhananjay Pawar
Kilo Sage

Hi,

For this you need to add that variable in attribute.

Right click on Hiring Manager variable and there you will find attribute field there you can add one more column of user id.

 

Thanks.

Sandeep Rajput
Tera Patron
Tera Patron

@Ak8977 Please update the variable attribute of your hiring manager variable as follows.

 

Screenshot 2024-05-02 at 11.29.38 AM.png

Here is the variable attribute value.

 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email;user_name,ref_ac_order_by=name,ref_ac_columns_search=true,ref_ac_display_value=false

Hope this helps.

Astik Thombare
Tera Sage

Hi @Ak8977 ,

 

Please open record for 'Hiring Manager ' Variable and Please go to 'Type Specifications' Related List and Update the Variable Attribute Field as Below

 

 

ref_ac_columns=user_name;email;sys_created_on 

 

 

Whatever fields you want to display . you can edit above attribute as per your sequence . Please check below screenshot .

 

AstikThombare_0-1714630235786.png

 

The outcome-

 

AstikThombare_1-1714630316577.png

 

 

   If my reply helped with your issue please mark helpful 👍 and correct ✔️ if your issue is resolved.

 

                         By doing so you help other community members find resolved questions which may relate to an issue they're having

 

 

Thanks,

Seraj
Tera Guru

Hi @Ak8977 

 

Just Configure the variable attributes property in your catalog item variable field eg. 'Hiring Manager'

Paste below script in your variable attribute field

 

ref_ac_columns=name;email;user_name;

 

 

Please refer to attached picture

Thanks & Regards

Seraj