Reference variable showing unexpected value

[GraurSebastian]

I have this variable that should show me the u_phone_number records and after some research i found out this attribute that allows me to see what i want but unfortunately it didn't work
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_phone_number,ref_ac_columns_search=true,ref_ac_display_value=true

And the only field from the table that has the checkbox "Display"-true is Phone Number, can someone tell me if there could be a solution?
And after selecting a record the value that is displayed is the Location, it should be Phone Number

[Brad Bowman]

Is the advanced reference qualifier working / only showing the (correct) records for the selected 'location' variable?  If not, try without any qualifier to see if the attributes are honored on typeahead search. And to clarify, this is the view affected by the attributes, not if you click the reference search icon (magnifying glass)

To alter the reference search view, right-click the column headers in the dialog window where the filtered results are shown, then choose Configure > List Layout to select the desired columns and order.

As far as the display value when a record is selected in the reference variable, if you display a record from this custom table is outside of this reference variable / catalog item, which field is shown in bold in the top left corner, underneath the table name? It should be the same as displayed on a selected reference variable/field.  If this table is extended from another, the display column of the root table will be the one shown.

[GraurSebastian]

Hello Brad, thank you for the answer, it worked for me to understand some thinks, and indeed the table is an extended one, how can I alter what is displayed in this case and not affect the root table?

[Brad Bowman]

On the root table, for the column that is the display column, try creating a Dictionary Override record for the extended custom table.  In this case, none of the boxes will be checked.  I did this with an out of the box example - incident, which extends the task table.  On the Dictionary Entry for the Number column, which exists on the Task table, I created a Dictionary Override for the incident table, leaving all of the boxes unchecked.  On the Caller id column on the incident table, I then changed Display to true, and it shows this on incident records only.

If the phone number field exists on the root table, you would need a Dictionary Override record on that table as well (or maybe instead of the empty one) for your extended custom table with the Override Display box checked.

[saivenkates5338]

Hi @GraurSebastian 

Try writing that In variable attributes instead of reference Qualifiers 

Thanks and Regards

Sai Venkatesh