showing different field values in different column in reference type variable

[Amit Dey1]

Hi , I have created a reference type variable in a catalog form , I want to show a column value of the table in the the first column in reference list and another column value in the 2nd column in the reference list , how can I achieve this

[Akshay37 · Accepted solution]

Hi Amit,

Use 

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

this syntax to show multiple columns in reference field , specify comma separated list of columns to "ref_ac_columns" this attribute in reference type specification of catalog item 

Please Mark it as correct/helpful if this helps you.

Thanks,

Akshay

[Amit Dey1]

hi , how to order those 2 column  , suppose those 2 column names are  column1 & column2

I have wriiten like this -  ref_ac_columns=column1;column2,ref_ac_columns_search=true,ref_ac_order_by=column1;column2,ref_auto_completer=AJAXTableCompleter

but it is still showing column2 first then column1

[Akshay37]

Hi Amit,

@Amit Dey1 

It's the possibility that column 2 might have  display=true set in reference table that's why it's always showing first. Please check this in the table you are referring.

Please mark this correct/helpful if this helps you

Thanks,

Akshay

[Amit Dey1]

hi it worked thanks