CA Service Management

 View Only
Expand all | Collapse all

Change tickets show based on workflow task name in scoreboard

  • 1.  Change tickets show based on workflow task name in scoreboard

    Posted Jul 22, 2019 12:50 PM
    Edited by Aamir Khan Jul 22, 2019 03:06 PM
    Hi 

    Can anyone help me with scoreboard query. I need to customize scoreboard in such a way that it show only those change tickets which are pending on  Workflow Task name 'Head IT Bream' 

    I used below constraint but it  gives error 'invalid constraint'.
    AHD05800:Bad where clause. invalid constraint. Unable to resolve tskty.sym.
    Please advise.


    tskty.sym = \'Manager\' AND status = \'PEND\'

    Thanks

    #ca_sdm_17.1
    #scoreboad
    #ca_sdm_14.1​​​​​


  • 2.  RE: Change tickets show based on workflow task name in scoreboard
    Best Answer

    Posted Jul 22, 2019 11:32 PM
    Hi,

    The problem is because you are using the wrong field, the query should be like task.sym = \'Manager\' AND status = \'PEND\', the task field is the SREL relation between wf object and tskty object.



    Regards,
    Yonatan Sosa

    ------------------------------
    Regards,
    Yonatan Sosa Sanchez
    Services Specialist
    ------------------------------