- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2022 10:16 PM
I set the following ref_ac_columns condition in variable attribute to make var1 and var2 visible in the reference variable on the Portal.
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=var1;var2,ref_ac_columns_search=true,ref_ac_display_value=false
However, when I checked the result, the display name is shown on the left of the reference variable as below.
Please let me know how to remove the display name and make only var1 and var2 shown.
Best Regards,
Aki
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2022 10:48 PM
Hi,
Couple of things to note here.
1) By Default there is a Display Value set for reference field and say if it is not set it takes up Name as the default Display Value.
2) Since your variable is a Reference Variable, I doubt you will be able to hide the extra column you are looking for.
3) Ref AC attribute allows you to display Extra columns here along with Display Value.
4) ref_ac_columns_search allows you to search with any columns including display which you have provided in your Variable Attributes section.
I just tried it in my PDI and don't think you will be able to remove that.
Please refer the below blog which will help you understand more on Variable Attributes:
https://snprotips.com/blog/2016/2/22/referencelist-attributes
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
Regards,
Shloke

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2022 10:28 PM
Hi,
According to the docs, it should be possible by setting: ref_ac_display_value=false
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2022 10:40 PM
Hi OlaN,
Thank you for the info. I added "ref_ac_display_value=false", but the result didn't change...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2022 10:56 PM
Okay, I have never tried using it, so I'm uncertain what is actually does.
Then I guess it's as Murthy and shloke04 already said, since it's a reference value, you won't be able to remove the displayvalue from the values being shown.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2022 10:28 PM
Hi Aki,
Hence it is a reference field its not possible to remove display name.
Murthy