question How to modify the display order of list data in a custom table？ in CSM forum

How to modify the display order of list data in a custom table？

shiz — Fri, 25 Jul 2025 09:16:54 GMT

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?

Re: How to modify the display order of list data in a custom table？

Community Alums — Fri, 25 Jul 2025 09:26:14 GMT

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

Re: How to modify the display order of list data in a custom table？

pawank2 — Fri, 25 Jul 2025 09:27:42 GMT

Hi Shiz,

Hi,

Navigate to the list view of your custom table.

Right-click on any column header and select Configure > List Layout.

In the "List Layout" slushbucket, you will see the "Available" and "Selected" columns.

Move columns between "Available" and "Selected" using the arrows, and reorder the "Selected" columns by dragging and dropping them or using the up/down arrows.

Save the changes. This will affect the column display order for that specific view for all users, unless a user has personalized their own list layout.

can you please check?

Re: How to modify the display order of list data in a custom table？

shiz — Fri, 25 Jul 2025 09:32:13 GMT

I don't seem to have found the third step yet? How should I set up sort?

Re: How to modify the display order of list data in a custom table？

GlideFather — Fri, 25 Jul 2025 09:34:53 GMT

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

Re: How to modify the display order of list data in a custom table？

Chaitanya ILCR — Fri, 25 Jul 2025 09:41:24 GMT

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

Re: How to modify the display order of list data in a custom table？

Pranesh072 — Fri, 25 Jul 2025 09:42:51 GMT

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.

Re: How to modify the display order of list data in a custom table？

shiz — Fri, 25 Jul 2025 09:42:52 GMT

What I want is sorting based on data rather than module.

Re: How to modify the display order of list data in a custom table？

Ankur Bawiskar — Fri, 25 Jul 2025 09:47:29 GMT

@shiz

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

Control Sort order for list

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: How to modify the display order of list data in a custom table？

Ankur Bawiskar — Mon, 28 Jul 2025 03:15:54 GMT

@shiz

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.