Advance Reference Qualifier returning values in two columns

chatsaurav19
Tera Contributor

Hi All,

 

I have defined an Advance Reference Qualifier for a variable like this but it is returning the correct values in two columns whereas it should show as one column only.

 

chatsaurav19_0-1701789786795.png

 

chatsaurav19_1-1701789817786.png

 

Any idea how it can be rectified?

 

Thanks and Regards,

Saurabh Chatterjee

1 ACCEPTED SOLUTION

Elijah Aromola
Mega Sage

You have to specify the columns you want to show in the variable attributes. The reference just determines what records are shown. The ref_ac_columns attribute shown below is used to specify the fields displayed on search.

 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=column_name_you_want_visible
 

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/field-administr...

View solution in original post

2 REPLIES 2

Elijah Aromola
Mega Sage

You have to specify the columns you want to show in the variable attributes. The reference just determines what records are shown. The ref_ac_columns attribute shown below is used to specify the fields displayed on search.

 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=column_name_you_want_visible
 

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/field-administr...

Thank you @Elijah Aromola ... It worked...