Default sort of records using reference qualifier

DanielMR22
Tera Contributor

hi

I have a custom table and a new requirement is to create a new column, Order, to set the order on which the records should display as default. This table is display in a reference field, so I'm passing a list of sysIDs to the reference qualifier to get the data. 

 

The only way I found to implement this functionality was creating a user preference (without user) and removing the existing ones for that table.  It works, but once the user changes the column order on the list view, the default order won't work anymore. Is there any way to force this or to restrict changing the order of a table?  Thanks

1 REPLY 1

Maik Skoddow
Tera Patron
Tera Patron

Hi @DanielMR22 

 

basically you can extend any encoded query with the following term to enforce sorting by a certain field:

 

^ORDERBYfield_name

 

Maik