Default Sort on sysapproval_approver

[thenning]

We use a related list on our change records to list the individual approvers assigned to the change. If the user does not select a column to sort by, how do we get the default to sort on the approver name field? In the sysapproval_approver.approver field, I set the defaultsort value to 1, all other values in the table are null. So I thought it would sort by approver but it doesn't appear to be doing that. Since it's a reference to the sys_user.name field, I set the defaultsort on that field in the sys_user table to 1 also. Still not getting the desired results.

Any suggestions?
Thanks

[benn23]

I think this is what you're looking for...
Go into the change form and perform a sort on the column (approver).
Then jump into the "User Preferences" module, and do a sort (a-z) on the 'updated' column (you may have to bring that column into the list).
Find the sorted preference record that you just created... Open it up, remove your name from it, and check the 'system' checkbox.
Go back to the user preferences list, do a search on the name 'change_request.db.order.direction' and wipe out any others that you find (not the one you just defined as 'system').

[msrishilpa]

Hi Benn,

We are having similar kind of requirement with some changes.

we have created reference field in variable set and it is referring location table. when user click on reference icon, he suppose to get list of locations based on order by two fields and this has to be fixed order by list for all users.

For this I have added some condition on advanced reference qualifier of variable in variable set.

i.e. &sysparm_fixed_query=ORDERBYu_order^ORDERBYu_name&sysparm_order_direction=asc

but this is not working

Please help me if you have any information on it.

[andyliu]

It works. Thanks benn23!

[thenning]

This worked.
Thanks