How can I interchange the columns Name and Email which are displaying in reference field on Portal

[DP_3105_2]

I am having this requirement where I have to interchange the columns name and email which are auto displaying when we click on reference field. I have tried with variable attribute but the name column always remains there. Please suggest some solution

[GlideFather]

@DP_3105_2 @Ankur Bawiskar 
I just simulated this in my PDI and Ankur is right, the first column cannot be replaced, however the following order of the columns is editable

ref_ac_columns=name;email;first_name;last_name;
versus

ref_ac_columns=name;last_name;first_name;email;

It will be accordingly, removing the "name" or changing its position doesn't have any impact, just the second and further columns.

Please accept our solution due to the efforts we made in this. Thank you

[DP_3105_2]

Hi @Ankur Bawiskar  thanks for your response but I have checked in User(sys_user) table for the name field Display value is false which is OOB configuration

[Ankur Bawiskar]

@DP_3105_2 

yes that's correct. on sys_user table there is no field which is marked as Display=true

This is how system determines the display value 

Since sys_user table doesn't satisfy 1st 2 conditions, it checks the 3rd and finds name as exact column name and hence uses name as Display field

If my response helped please mark it correct and close the thread so that it benefits future readers.