CA Service Management

Expand all | Collapse all

LIST_IN/LIST_CR - ORDER BY TIME_TO_VIOLATION (mintime)

  • 1.  LIST_IN/LIST_CR - ORDER BY TIME_TO_VIOLATION (mintime)

    Posted 12-12-2017 07:28 AM

    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



  • 2.  Re: LIST_IN/LIST_CR - ORDER BY TIME_TO_VIOLATION (mintime)

    Posted 12-13-2017 10:47 AM

    I tried the same on 17.0 and it worked.

    which SDM version are you working with?

    Regards

    .........Michael 



  • 3.  Re: LIST_IN/LIST_CR - ORDER BY TIME_TO_VIOLATION (mintime)

    Posted 12-16-2017 10:23 AM

    I'm working with 14.1 cum3 version,

    Thanks