Display Unique Values in Reference list of Variable in Record Producer

Nishant26
Tera Contributor

HI @Ankur Bawiskar 

 

I have a requirement where I need to display only unique values in the reference list of Variable in Record producer. the variable refers to table(u_abc) where there is a field "state" and it has multiple records with the same state. for ex. there are multiple records in the referenced table with same state "MH" , therefore when the user clicks the reference variable then it shows multiple records with same "MH" and it is confusing for the user to select the state.

 

There could be many different states with the multiple records in the referenced table but we only want unique value of each state in the reference list of the variable. How can this be achieve.

 

Thanks!

1 REPLY 1

Community Alums
Not applicable

@Nishant26 --

 

If you have another field on you custom table that you are referring to then you can follow below.

1)Click on reference variable where you have already referred your custom table.

shraddhaDSawant_0-1691734978353.png

 

2)Configure the list layout then add any unique field for the custom table as I have number field on custom table so I have added that and then you will be able to select state for particular record.

shraddhaDSawant_1-1691735267674.png

In my case Number is unique and for each record there are multiple states.