How to set default order of list by reference field value

[Marcin Witosla1]

Hello everyone,

How to set default order of list by reference field value? isOrder=true works fine on String field types, but not onto reference one

User preferences with System checkbox ticked are not solving issue neither.

Reference field is called u_parent and its reference is Incident table is used in Damages incidents.

i have tried in Daqmages module in arguments &sysparm_order=u_parent &sysparm_order_direction=desc

I have tried in sys dictionary to set attributes for this field reference_sequence = field_name;

still not working

field needs to be sorted DESC on the list

Please help

[Ankur Bawiskar · Accepted solution]

Hi,

Sort doesn't work in reference field. I tried it earlier but it didn't work I guess.

check link below:

https://community.servicenow.com/community?id=community_question&sys_id=ebcc4329db9cdbc01dcaf3231f96...

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur