Display 3 variables value in lookup select box drop down.

[Ashwini Jadhao]

Hi,

I have created variable with type Lookup select box and it is refereeing to custom table.

Custom table contains 3 fields and I want to display those three fields in look up drop down.

For that I have used varaible attribute to as below:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_business_option;u_name_controller;u_email_id

but it is not working

[Voona Rohila]

Try this,modify field names accordingly.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_business_option;u_name_controller;u_email_id,ref_ac_columns_search=true,ref_ac_order_by=name

[Ashwini Jadhao]

thanks Rohila,

But it is not working

[Voona Rohila]

Hi,Can you show the updated configuration?are you not getting any fields?

You should type starting and remaining will be searched and showed along with fields you mentioned.(below image for reference)

[Voona Rohila]

Hi,Can you show the updated configuration?are you not getting any fields?

You should type starting and remaining will be searched and showed along with fields you mentioned.(below image and code for reference)

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_hiring_manager;u_select_user;u_requestors_business_unit,ref_ac_order_by=u_hiring_manager

[Anil Lande]

Hi,

Please check using admin and end User. 

If Admin is able to see these added columns and End user is not able to see these columns then check table_name.column_name Read ACL's. 

There is possibility that the access to these fields is restricted by ACl's.

Thanks,
Anil Lande