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]

Hi,

can you share the screenshot?

Regards
Ankur

[Pil Lot]

Hi,

Thank you for the response. Here is the screenshot.

[Ankur Bawiskar · Accepted solution]

Hi,

you should add this as well to allow searching

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name,ref_ac_columns_search=true

Regards
Ankur

[Pil Lot]

That did work, thank you so much!