How to get serial number in list collector variable from alm_hardware table

[bhargavi143]

Hi,
I need to get serial number values in List collector filter instead of display value.

Please find the above screenshot , In that i need to display the serial numbers of Assets instead of Display values of Assets.

[Manmohan K]

Hi @bhargavi143 

List collectors only display the field that is set as display = true.  You cannot have more then one field with display = true. so that's not possible

An alternate approach would be to add variable attributes which will allow users to see serial number along with display name. But this will only work in portal when user searches on list collector and not on native view

variable attributes you can add : ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;serial_number,ref_ac_columns_search=true

[bhargavi143]

Thank you Manmohan for reply on my query,

If any other to achieve this in native view means by using Script is it possible. If it possible please share the Script.

 Thank you in Advance.

[Manmohan K]

@bhargavi143 

Unfortunately there is no way to achieve it in native view.