Resolution:
SQL query to list the system attributes of the last confirmed version records in a repository.

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

Symptoms:

None

Cause:

N/A

Resolution:

The following query can be used to list the last confirmed version records in a repository with the system attributes.

SELECT
PK.CATALOGID, PKEY.NAME PRODUCTID, PKEY.EXTENSION PRODUCTIDEXT, PK.PRODUCTKEYID, PK.MODVERSION,
PK.ACTIVE, PK.CREATIONDATE, PK.MODDATE, PK.CHECKSUM, PK.STATE, PK.LASTCONFIRMEDVERSION,
MR.USERNAME USERNAME, MR.LASTNAME LASTNAME, MR.FIRSTNAME FIRSTNAME
FROM PRINCIPALKEY PK, PRODUCTKEY PKEY, MEMBER MR
WHERE
PK.CATALOGID = 40686 and PK.PRODUCTKEYID = PKEY.ID AND
MR.ID = PK.MODMEMBERID AND
PK.MODVERSION = (SELECT MAX(MODVERSION) FROM PRINCIPALKEY PK1 WHERE PK1.PRODUCTKEYID = PK.PRODUCTKEYID)


Attachments:

None

References:

None

SQL query to list the system attributes of the last confirmed version records in a repository.