CABI Report On Special Handling Group Members?

[STUART MATTHEWS]

Does anyone know how to create a CABI report that will return the inactive members of a specified Special Handling group.

 

Basically the equivalent of this stored query against the contact table. 

 

delete_flag=1 AND cnthandling_list.special_handling IN (400001)

 

I couldn't find a way using the CA Service Desk universe for SDM 12.9

 

CABI Build Number:  1983 
CABI Product Version:  12.7.0.1983 

 

Thanks Stuart

[STUART MATTHEWS]

I had another look at this today and solved the issue, different names between the universe objects, schema designer and DBMS can be confusing.

 

 

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
  (
   cnt_handling.delete_flag  =  1
   AND
   contact_handling.special_handling  =  400001
  )