LIST_IN/LIST_CR - ORDER BY TIME_TO_VIOLATION (mintime)

[Legacy User]

Is there a way to sort the list of tickets (incidents / requests / problems) by the column mintime (time_to_violation)?

 

I try to modify the domset (cr_list_web / in_list_web) and it gives an attribute error that does not exist in the DOB.

 

I try:

 

MODIFY FACTORY

 

MODIFY FACTORY in
{
DOMSET in_list_web "mintime=min(attached_slas.time_to_violation),zSLA_status ASC, open_date DESC, id DESC, status=status.sym, priority=priority.sym DESC, ref_num" "" STATIC;
DOMSET in_list_web_active_only "mintime=min(attached_slas.time_to_violation),zSLA_status ASC, open_date DESC, id DESC, status=status.sym, priority=priority.sym DESC, ref_num" "" STATIC { WHERE "active=1"; };
};

MODIFY FACTORY cr
{
DOMSET cr_list_web "mintime=min(attached_slas.time_to_violation), zSLA_status ASC, open_date DESC, id DESC, status=status.sym, priority=priority.sym DESC, ref_num" "" STATIC;
DOMSET cr_list_web_active_only "mintime=min(attached_slas.time_to_violation), zSLA_status ASC, open_date DESC, id DESC, status=status.sym, priority=priority.sym DESC, ref_num" "" STATIC { WHERE "active=1"; };
};

 

Error:

 

12/09 10:54:06.62 SCMDBLAB1      domsrvr              4612 SIGNIFICANT  domset.c              2732 Adding sort column "min(attached_slas.time_to_violation)" to list format in_list_web for factory in 12/09 10:54:06.64 SCMDBLAB1      domsrvr              4612 ERROR        domset.c              2840 Attribute min not found in cr:PDOB:PATTR:OB:MTH:

 

Thanks

[Michael Mueller]

I tried the same on 17.0 and it worked.

which SDM version are you working with?

Regards

.........Michael 

[Legacy User]

I'm working with 14.1 cum3 version,

Thanks