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: 18.104.22.1683
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_symbolFROM 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 )