Display multiple columns in Reference list of Variable in Record Producer

[Nishant26]

Hi @Ankur Bawiskar ,

I have a requirement where I need to display multiple columns in the reference list of variable in Record Producer. Right now, it only displays Sys_id column in reference list after clicking.

Both Record Producer and Referenced table are in different application, how can this be achieve.

Thanks!

[Ankur Bawiskar]

@Nishant26 

there should be some field marked as Display=true in your table.

Once that is present the display field will be shown when user clicks the lookup icon

OR

Did you check by configuring the list layout of that table when user clicks the lookup icon?

[Nishant26]

I have made one field display = true on reference table(u_abc), I have also configured the reference list for the reference table(u_abc) table from UI views. Now I can see all the fields that I have configured on the reference list when the user clicks the lookup icon.

Problem is both variables on Record producer "state" and "center" refers to the same fields "state" and "center" on table(u_abc), now what is happening when the user clicks the lookup icon for both of the variables on the record producer, it displays the reference list is similar way, i.e. I can only select state field value as this is the first column, this will work for the "state" variable but for the other variable "center" I can't select the "center" value from the reference list since it is at position 2 in the columns. 

Also, there are duplicate records in the "state" column of the reference list, I only want unique value in this column, where after selecting the "state" value from the reference list, the "center" variable look up should displays values of "center" column in the reference list which are associated with a particular "state". 

I have created one more question for this:

https://www.servicenow.com/community/itsm-forum/display-unique-values-in-reference-list-of-variable-...

[Ankur Bawiskar]

@Nishant26 

since both the variables point to same table it's not possible

[Nishant26]

is there any workaround for this? Also, how can I get unique values in the "state" variable?