How to display preferred column for list collector variable

aryanjain27
Tera Contributor

Hii All,

 

I've a list collector variable on a catalog item and am using Reference qual to filter out the options in the field. But a random "Created On" are being displayed in the options. I would like to have a specific column show up in the options. The reference qual is able to filter those out but the display name in the options are not working. I also used variable attributes to get that but still getting the "created on...." as names and not the column.
The variable attribute I'm using is: 

 

 

ref_ac_columns=column_name,ref_ac_columns_search=true,ref_ac_order_by=name

 

 

 

I've an another lookup select box variable thats referencing the same table and same filter, but since this variable has an explicit field for lookup field value, I'm able to select the column and its working fine. But I want to have the ability to select multiple items. Both the variables are able to filter out right. Does someone know how we can have an equivalent to "lookup field value" for list collector.
If there's any other way we can have a variable similar to the lookup select box but with multiple select ability, pls do let me know.

 

Thnx in Advance! 

2 REPLIES 2

Abhay Kumar1
Giga Sage

@aryanjain27 Pls try below of works for you,

ref_ac_columns=column_name,ref_ac_display_value=true,ref_ac_columns_search=true,ref_ac_order_by=column_name

 

ref_ac_columns: Specifies the columns to show in the auto-complete suggestion list.

 

ref_ac_display_value: Forces the list collector to use the display value.

 

ref_ac_order_by: Orders the options by the specified column.

Hii @Abhay Kumar1 ,

Still the options show "created on" rather than the field name. This is a dependent variable, that depends on the selection of option from another variable. But the filter is working as when I select an option the num of items that should show up is right but the display name is "created on".