Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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...