To sort name field by last name

shraddhap · ‎04-07-2017

Hello,

We have modified the Name field on sys_user table to return "Last name, first name" but when we sort on name field column its sorting by first name.

Sorting works fine for newly created users but for old records its sorting by first name. Any suggestion?

Regards,

Shraddha

shraddhap · ‎04-12-2017

Hello Shloke,

Thanks for the reply, I tried using ASC but still it was not working. So, I did this in an another way, as sort was not working for old user records and in order to make it work for old user entries as well , have created a background script to update all active users for old user records.

So, created a new field as "User Sort" on user table and set the default value as "True",using background script I have set the value as false and now it works fine.

Regards,

Shraddha

View solution in original post

amlanpal · ‎04-07-2017

Hi Shraddha,

You can sort any field either by URL or by using Business rule. Please find both the ways here in the below threads:

1. Set Default Sort Order for lists in Mobile view

2. How to specify default sort order for a specific module in Mobile View?

I hope this helps.Please mark correct/helpful based on impact

amlanpal · ‎04-12-2017

Hi shraddhap,

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View