+2
hi,
I added the dynamic model for tracing data, but the extra columns cannot be used for sorting the list:
As tracing data is at best when sorting at the updated time, how can I use these columns for default sorting?
Best answer by Renée Evertzen
View original
+3
Hey Tejo,
While it is true that any generated column cannot manually be included in the columns used for sorting, it is theoretically possible to modify the dynamic control procedure to include these columns in the sorting order of the table, depending on how this functionality was implemented in your project. Unfortunately this is something that I cannot determine based on your post alone.
If this is also not an option you can considering adding a hidden expression field to the table that selects the trace value and use that for sorting instead.
Hope this helps!
+2
Thanks Renée, I’ll take this question with me to TEC to figure out the dynamic model.
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_timeNote 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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.