Is there any SQL query to check if the record is deleted from the master catalog or not?
Article ID: KB0085797
Updated On:
| Products | Versions |
|---|---|
| TIBCO Collaborative Information Manager | - |
| Not Applicable | - |
Description
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 = <catalogid> AND PRODUCTKEYID in (select cproductkeyid from MCT_<catalogid> where cproductid='<productid>') and ACTIVE='N'
Please replace <catalogid> and <productid> per your setup.
Attachments:
None
References:
None
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 = <catalogid> AND PRODUCTKEYID in (select cproductkeyid from MCT_<catalogid> where cproductid='<productid>') and ACTIVE='N'
Please replace <catalogid> and <productid> per your setup.
Attachments:
None
References:
None
Issue/Introduction
Is there any SQL query to check if the record is deleted from the master catalog or not?
Feedback
Yes
No
Powered by
