Default sort of records using reference qualifier
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 10:32 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2025 07:00 AM
Hi @DanielMR22
basically you can extend any encoded query with the following term to enforce sorting by a certain field:
^ORDERBYfield_name
Maik