- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2025 02:16 AM
I have a custom list as follows:
I would like to sort the data based on the above fields during the initial display stage. How should it be set up?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2025 02:41 AM
Hi @shiz ,
go to user preferences
and create a new user preference
with name yourtablename.db.order
value with your field name (in this case it's module field backend name)
replace <table_name> with your table name and <field_name> with your field name
and set system = ture
if you find any other user preference with name where user is populated delete those
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2025 02:42 AM
Create 2 new entries on the user preference table [sys_user_preference]
[table name].db.order - Field name used for sort
[table name].db.order.direction - DESC/ASC
Mark them as system and delete any other same entries present for your custom table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2025 08:15 PM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2025 02:26 AM
Hello @shiz,
Configure List Layout with Default Sort Order
Navigate to the list you want to customize.
Right-click the column header (or gear icon) → Configure → List Layout.
Ensure your custom fields are included in the list view.
Then, click the gear icon again → Sort.
In the Sort dialog:
Select your fields (one or more) to define the default sort order.
Choose Ascending or Descending for each.
Click OK → Save.
Please mark my response as Accepted and Helpful for future references.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2025 02:32 AM
I don't seem to have found the third step yet? How should I set up sort?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2025 02:27 AM
Hi Shiz,
Hi,
Navigate to the list view of your custom table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2025 02:32 AM - edited 07-25-2025 02:34 AM
Hi @shiz
any module global or scoped, hover over to the right and Edit module icon will appear:
and update accordingly:
Optimally do this for the Application - that is the collapsible pr expandable part:
Click Customer service to reorder the Cases and Open,
Click Problem to reorder the Open, Open- Unassigned, Change, ....
Keep me updated on your progress
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */