- 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:42 AM
What I want is sorting based on data rather than module.
- 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-25-2025 02:47 AM
you can have a default sort on table list via user preferences and it will apply to all users
But if later user changes that then it will sort as per that user's preference and will be overridden.
check this
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-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