Defaulting Integer Field to be sorted A to Z (numerically)

[clifforddog]

Hello SNC,

I have created a field on my change task table and would like for the CTASK to be automatically sorted from A to Z (increasing numeric value eg. 1,2,3).

I know that for my own perosonal view that I can click the field and sort A to Z, but I would like all CTASKs for all users to be automatically sorted in numerical order so that each individual user does not have to change their own personal view by clicking on the field. I have attached a screenshot below

[dvp · Accepted solution]

You can set it in user preferences table

[dvp]

In my earlier screenshot I missed the field name. I just noticed it

Here is the updated one

let us know your results

[clifforddog]

I got it figured out in the interim, before I saw this and my results were the same as you have. Thanks!

[Lottet13]

Hi- I am trying to do a similar thing.

My table has a risk rating field for one of the 5 options: 5 - Critical; 4 - High; 3 - Medium; 2 - Low; 1 - Negligible.

When I generate a report, I am only able to sort the field alphabetically even though the text for each option is preceded by a number. 

I tried the approach suggested in this forum but couldn't get it to work.

(Under User Preferences I created the "(table name).db.order" as well as "(table name).db.order.direction" with value "u_sequence" or "number" and neither works.)

Any help would be great! Thnx.