how to set a default sort field for the list layout of a table when opened as a reference table

Ravish Shetty
Tera Guru

Hi all,

 

We have a below field which refers to a given table

 

RavishShetty_0-1699033565698.png

when we click on the magnifying glass, it opens the list layout in a pop up of the referred to table

 

RavishShetty_1-1699033677018.png

The dictionary entry of the 'Patch window duration' field is as below. we see that the dictionary attribute is set so that the default sort is using the 'u_subtype' field on the referred to table.

 

RavishShetty_3-1699033766333.png

 

Now because i clicked on the 'value' header, it sorts by the 'Value field'. seems this is stored in the user preference. 

 

RavishShetty_2-1699033720181.png

 

how do I lock the sorting behavior so that the sort is always done through the 'u_subtype' field?

 

Thanks,

Ravish

1 REPLY 1

Jaspal Singh
Mega Patron
Mega Patron

Hi,

You may need to delete the user preference for the table as and when it gets added for required table to default it.