Want custom fields in reference qualifier

[Abishek1998]

Hi all,

I am stuck at one issue. The reference field for sys_user table is taking the first name and last name while searching in a reference variable. But Can I also add two newly created fields? which is u_test_fname and u_test_lname. So If i search these name also. I should get the user records. 

[yashkamde]

Hello @Abishek1998 ,

you don't need a reference qualifier script for this !

you need to add the ref_ac_columns attribute to the dictionary attribute.

from which you can search which any fields mentioned in attributes..

If my response helped mark as helpful and accept the solution.

[Ehab Pilloor]

@Abishek1998, 

If you mean search table using those field values, then add this code in your variable attribute and check:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_test_fname;u_test_lname,ref_ac_columns_search=true

Regards,

Ehab Pilloor

[Ankur Bawiskar]

@Abishek1998 

your question is easy.

Did you try searching docs before posting it?

That would have saved your time

[Tanushree Maiti]

Hi @Abishek1998 

1. Open your Catalog Item and select your reference variable.
2. Add the following comma-separated string to the Variable Attributes field:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_test_fname;u_test_lname,ref_ac_columns_search=true