Need to get the unique values for a reference field

[Yesh]

Hi Team,

My reference field is visible like this:

IM Argentina Operating Unit

IM Argentina Operating Unit

IM Argentina Operating Unit

IM Argentina Operating Unit

IM BR OU

IM BR OU

.............

But I need the unique Values.

How to achieve this requirement?

Thanks,

Yesh

[Tudor]

Hello Yesh,

Please try:

field = current.getValue(field_name);

As opposed to getDisplayValue - this will return the sys_id of the reference field.

Hope this helps!

 Tudor

[Yesh]

Hi Tudor,

I want the field Values only and these should be unique. I don't want sysID.

Thanks,

Yesh

[_ChrisHelming]

Go to the sys_db_object table, find your table, and set the field you want displayed as the display field.

[Yesh]

Hi Chris,

I have already set the display field. Here I need the unique values of that field. Do you have suggestion for this?

Thanks,

Yesh