Can I change the display column of reference table in Service catalog variables

Takuya Saito
Mega Contributor

I would like to change the display column of reference table in Service catalog variables.

For example, the table has two columns, category and type, and service catalog has two variables, that are reference same table. I would like to display one reference variable as category and another as type.

I know "ref_ac_columns", that can be filter by two columns in one variable. But it doesn't meet my requirement. I would like to use two variables that reference same table and display difference column.

Thank you.

1 ACCEPTED SOLUTION

Harshal Gawali
Giga Guru

Hello,

Instead of using two reference variable, please use two lookup select box variable.

Lookup select box also reference variable in which you can select different column of that table.

For reference check below screenshot.

find_real_file.png

 

Regards,

Harshal.

View solution in original post

6 REPLIES 6

Onkar Pandav
Tera Guru

Hi,

Just want to add here that, I believe it wont be possible.

You can not make the display value conditional on a single table.

For more clarification have a look at below threads.

https://community.servicenow.com/community?id=community_question&sys_id=25005fa5dbdcdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=9bb18f69db98dbc01dcaf3231f96...

 

Let me now if it helps.

Alp Utku
Mega Sage

You could change the variable type to "Lookup Select Box" rather than reference field.

You just need to select the table name and there is selection called "Lookup value field" you could select the column of table to be referenced.

manjusha
Kilo Guru
Hi, If you change display value of reference table then that new change will be applied to all other reference fields which are used somewhere else and refering to the same table. So this will cause a broblem. Thanks, Manjusha