List Collector - Alternate Display Name

[dbaril]

I have a record producer that contains 2 list collectors.  Both are pointing to the same custom table.  The first list collector is properly displaying the text values from the field that has "Display" set to True in the dictionary.

For the second list collector I need to display values that come from a different field on the same table.  I have tried setting the attribute value to:  ref_ac_columns=u_alternate_name, but the list entries all appear blank.  I know it's retrieving the correct records, as I can click a blank entry from the list and it displays additional details about the record below the list collector.

How do I force a list collector to display a text value other than the default?

[-O-]

It is not possible to hide the display value column in Catalog Item reference or list collector variables. You can display additional columns, but cannot hide the display value.

You could create a virtual table mirroring the original table and set that as source for the 2nd  table, of course selecting the alternate name as name in the script for the virtual table.

You could also create an extension (or use an existing extending table) and set its display column to the alternate name column.

But both might have licensing implications, so check for that before going forward should you consider it.