reference variable

[abhisek]

I have a reference variable 'incident number' which refers to incident table. When we click on the search glass of that reference field it will open the list of the incidents. The requirement is only incident number, assignment group and short description columns must be shown on that list.

Can anyone please help me out.

[Bhavya11]

Hi @abhisek  ,

Open the reference variable then goto 'Type specifications' section then scrolled down then in 

Variable attributes add these 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=<field 1>;<field2>,ref_ac_columns_search=true

Replace <field 1> with actual field names

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=number;short_description;assignment_group,ref_ac_columns_search=true

Please mark this response as correct or helpful.

Thanks,

BK

[abhisek]

Hi @Bhavya11 

Thanks for your reply. 

I tried this but not working.

[Bhavya11]

Hi @abhisek  ,

what is not working. could please share screenshot.

Thanks,

BK

[Uncle Rob]

Isn't this code just for type-ahead / auto complete?
If you click the magnifying glass on a reference field you'll still get the default list view I thought.