'Lookup Select Box' variable with 'sys_user' lookup table

[Simona6]

For service Catalog

Using 'Lookup select Box' variable to insert user name from table 'sys_user' , it show limited number of records as user count is too high.

My Requirement:

1)Want the usernam1 field in drop down format only

2)Is it possible to show username with email id in drop down.

3)Can i put condition that user having company name 'comp1' or 'comp2' should be visible for username1 field. 

[Mike Patel · Accepted solution]

#1 - Yes, It's dropdown only. It's better if you change it to reference field.

#2 - you can add below to variable attributes on your variable

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=email,ref_ac_columns_search=true,ref_ac_order_by=name

#3 - Once you change the variable type to reference you should be able to see filters and add your condition.

If you still want to use Lookup select box than you need to add something like below to ref equl

company.name=comp1^ORcompany.name=comp2 

[Simona6]

Thank you Mike .

Point 3 worked.

Can I show username as well as email address in drop down using lookup select box only not reference field?

[Mike Patel]

You can show username and email on lookup and reference type.

For lookup type you don't need variable attribute, you can do below

[Simona6]

I just want to know if there is any way to display as below format.

output-simon|simon@example.com

expect in this format-simon        simona@example.com(this format we get in reference field variable)