Can a default sort order be set on a table?

[jewellaubert]

I want to add a new module to the navigator and wanted to know if I can create a sorted view of a table. IE "Opened"  sorted in descending order.

[bammar · Accepted solution]

See if you can right click the Filter with the sorting you want to get the query/URL - the sort may be indicated by that- then you can force that exact url in the module settings. 

The issue i feel like you will run into is default sorting is set by admin- but users can and will change their sorting order and column to to sort by according to their preferences as wel as according to what they may be working or  researching on any given day. Once they personalize anything you set wont be there for those individuals..

[jewellaubert]

Thanks for the recommendation.  The module settings won't allow you to put a URL. 

[Ghazali]

Did you find a solution to this?

[Paul Curwen]

You can do this with User Preferences (sys_user_preference) For each table e,g, incident, Request you can define the default sort order and direction using 2 user preferences e.g.

incident.db.order - for the user preference value choose the field e.g. updated

incident.db.order.direction - for the user preference value choose either DESC or ASC

For both of the above you will need to define this for any table required and also ensure the System field is set to true. Of course users can still override this using a personal preference using the lisy view controls. 

If helpful please mark as Helpful/Correct