Type specification to show additional column in dropdown select box variable on a record producer?

[Daniel R2]

Hi, 

There is a requirement on my project to show the company that is linked to the business area code on the right hand side of the dropdown. In similar situations i have used "ref_auto_completer=AJAXTableCompleter,ref_ac_columns=backendnameoffield,ref_ac_columns_search=true". 

However i dont think i can use this ref_auto_completer here because, the business area code variable is not actually a reference field. It is an additional field on the companies form, so we have added this as a variable to a record producer by making it a lookup select box variable which looksup from the company table and then putting the business area code as the lookup value field. 

So i presume because its not actually a reference i can not use the ref_auto_completer? How can i show the company names that are related to the business area codes on the right handside of the dropdown?

[Musab Rasheed · Accepted solution]

Hello,

Check this out

https://www.servicenow.com/community/developer-forum/display-3-variables-value-in-lookup-select-box-...

[deepadokania]

But we can't search using those additional columns, have you able to figure out that?

[Daniel R2]

@Musab Rasheed - Thanks Musab, that helped a lot and helped me to solve the problem.

Thanks again

[Haviesh]

IN Variable attributes use this code: ref_ac_columns=u_business_option;u_name_controller;u_email_id,ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true
use coloumn names separated by ';'