Use generated columns in default sort

Thanks Renée, I’ll take this question with me to TEC to figure out the dynamic model.

@Tejo van de Bor We use Dynamic code for this particular purpose in our Project too, here's a slightly adjusted script for your purpose. Add the table name(s) to which you wish to apply this in the where clause (or remove the clause if you wish to apply it to all tables). Of course you could use different sort_order and sort_no values than below.

Tables:

declare @update_date_time varchar(50) = 'update_date_time'
update c 
    set c.default_sort = 1
    , c.sort_order = 1 -- Descending
    , c.sort_no = 10
    from col c 
    where c.tab_id in ('<table name>') 
    and c.project_id = @project_id 
    and c.project_vrs_id = @project_vrs_id 
    and c.col_id = @update_date_time

Note that for Variants which have Variant-specific Sort enabled you need to update another table and include both tab_id and tab_variant_id. 

update c 
    set c.default_sort = 1
    , c.sort_order = 1 -- Descending
    , c.sort_no = 10
    from tab_variant_sort_overview c 
    where c.tab_id in ('<table name>') 
    and c.tab_variant_id in ('<variant name>')
    and c.project_id = @project_id
    and c.project_vrs_id = @project_vrs_id 
    and c.col_id = @update_date_time

Thanks @Arie V this worked!