Hi Community,
Seems like doing following does the job except I need to restrict the sort as well
2.3 Default sort order
The system automatically sorts lists that meet one of the sort order criteria.
If there is a user preference specifying the sort order for the table, the system sorts by the field listed in the user preference.
If the table is the Task table or any of its extensions, the system sorts by the Number field.
If the table contains a field with the attribute isOrder=true, the system sorts by this field.
If the table contains an Order field, the system sorts by this field.
If the table contains a Number field, the system sorts by this field.
If the table contains a Name field, the system sorts by this field
is there a way I can restrict reference column once sorted?
Thanks in advance
AK
