Resolution:
Is there any SQL query to check if the record is deleted from the master catalog or not?

Environment:

TIBCO Product name and version: TIBCO Collaborative Information Manager 7.x
Operating System(s): All Operating Systems

Symptoms:

None

Cause:

None

Resolution:

You can use the following SQL to check if the record is deleted or not:

select count(*) from PRINCIPALKEY where CATALOGID = &ltcatalogid> AND PRODUCTKEYID in (select cproductkeyid from MCT_&ltcatalogid> where cproductid='&ltproductid>') and ACTIVE='N'

Please replace &ltcatalogid> and &ltproductid> per your setup.

Attachments:

None

References:

None