What could be the SQL query to find the last confirmed version records in a master catalog?
Article ID: KB0091813
Updated On:
| Products | Versions |
|---|---|
| TIBCO Collaborative Information Manager | - |
| Not Applicable | - |
Description
Resolution:
The GOLDENCOPY table in CIM database instance keeps track of all latest confirmed records which are active. You can use the following query to retrieve latest confirmed records which are active.
select MCT_XXXXX.* from MCT_XXXXX, GOLDENCOPY where MCT_XXXXX.CPRODUCTKEYID=GOLDENCOPY.PRODUCTKEY and MCT_XXXXX.CMODVERSION=GOLDENCOPY.VERSION
The GOLDENCOPY table in CIM database instance keeps track of all latest confirmed records which are active. You can use the following query to retrieve latest confirmed records which are active.
select MCT_XXXXX.* from MCT_XXXXX, GOLDENCOPY where MCT_XXXXX.CPRODUCTKEYID=GOLDENCOPY.PRODUCTKEY and MCT_XXXXX.CMODVERSION=GOLDENCOPY.VERSION
Issue/Introduction
What could be the SQL query to find the last confirmed version records in a master catalog?
Feedback
Yes
No
Powered by
