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 (cnt_handling.id=contact_handling.contact) 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

Outcomes