Auto complete in Reference Type Variable

[vintotz]

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 ?

[Deepa Srivastav]

Remove from there and goto reference field in the form --right click the field ->configure dictionary and put below in "attribute" field .

ref_ac_columns=last_name;

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

Thanks,

Deepa

[vintotz]

Thanks Deepa for you patience , however i cant find the "configure dictionary"   in my   variable in catalog item

[Deepa Srivastav · 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.

[vintotz]

Thank you so much Deepa, now it works.

[Deepa Srivastav]

Hi Vin,

Goto field right click->configure dictionary and put below in "attribute" field   .

ref_ac_columns=last_name;

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

Thanks,

Deepa