AnsweredAssumed Answered

Xtraction query to show VIP Users (Special Handle)

Question asked by Earamendi on Feb 26, 2018
Latest reply on Mar 5, 2018 by pier-olivier.tremblay

Hi there,


I would like if somebody can give me a hand with this scenario.


I will like to show in a Xtraction Dashboard, VIP users from CA ServiceDesk that they have an open Incident or Request. (As far as I know, this is a "Special Handle" condition that is added to the user in CA Service Desk).


I requested a chat with Support and they provided me the following query


SELECT contact_handling.contact_combo_name, cnt_handling.delete_flag_symbol FROM contact_handling INNER JOIN cnt cnt_handling ON ( WHERE contact_handling.special_handling = 400001


What I would like to know if how to edit the data model to add this info.


Support Case reply to ask on the community...


thanks in advance