Auto complete in Reference Type Variable

vintotz
Tera Contributor

Hi Everyone, any idea on how to modify the auto complete feature in a reference type variable.

i have this issue with a variable referenced to sys_user table. it only allows you to enter first name of a user so that the auto complete will work.

is it possible to modify this so that it accept either first name or the last name of user ?

1 ACCEPTED SOLUTION

Put below in "variable attributes" in default value tab.



ref_auto_completer=AJAXTableCompleter,ref_ac_columns=first_name;last_name,ref_ac_columns_search=true,ref_ac_display_value=false



Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.



attribute.png


View solution in original post

11 REPLIES 11

ganesh7
Kilo Contributor

Hi Vin,



Write OnChange Client script like



function onChange(control, oldValue, newValue, isLoading) {


  field = g_form.getReference('field');


  g_form.setValue('filedname', field.value);


}



Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.



Regards,


Ganesh.


akshaybhardwaj
Mega Guru

Hi Vin,



Right click on the variable goto configure variable->open that variable in default view->goto default value tab->below you will see attribute field you can post your attribute there   ref_ac_columns=last_name



Regards,


Akshay