CA Service Management

 View Only
  • 1.  where clause

    Posted May 15, 2023 04:38 AM

    can someone guide me how to write where clause query of customized score board? What attributes are used? And what's the syntax?



  • 2.  RE: where clause

    Posted May 17, 2023 08:42 AM

    You can started look the documentation about Scoreboard.

    Scoreboard Queries

    There is many example



    ------------------------------
    Regards,
    Felipe Vandrilho

    Linkedin: https://www.linkedin.com/in/vandrilho/
    ------------------------------



  • 3.  RE: where clause

    Posted May 18, 2023 12:29 AM

    Thankyou!
    can you please guide me how to see the incidents that are transferred from one specific group to all the other groups?
    OR number of incidents that are transferred from one group to all the other?




  • 4.  RE: where clause

    Posted May 23, 2023 03:35 PM

    In the ticket record, there is only the currently assigned group. As there is no OOTB (out of the box) field that stores the previous group, you would need to add a custom field and develop custom code to populate the field whenever the group is changed.



    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants LLC
    ------------------------------