Variable attributes on Reference to sys_user table

[Pil Lot]

Hi Everyone,

Working with a catalog Item. I am trying to use a reference variable to the user table but everytime I type something it always mataches on email ,first name or last name. I am trying to to make the userid autocomplete as well.

I've tried using "ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name" in the Variable attributes with no luck. Also tried Lookup select box but has a limit of 10k records.

Thanks you in advance.

[Ankur Bawiskar]

Glad to help.

Please mark response helpful as well.

Regards
Ankur

[RWHeals]

ive configured the same, but when testing as a public user (not logged in), the search only works on the display field, not all fields in ref_ac_column.  Is this a known limitation, or have i configured incorrectly?

ref_ac_columns_search=true,ref_ac_columns=name;identification_number,ref_auto_completer=AJAXTableCompleter