Number of versions for a specific object
Object versions are related to each other by the i_chronicle_id attribute. The DQL counts the number of objects with the same i_chronicle_id. Any r_object_id of a document in the version tree can be used
SELECT count(r_object_id) FROM dm_sysobject (ALL) WHERE i_chronicle_id IN (SELECT i_chronicle_id FROM dm_sysobject WHERE r_object_id='< object id >'
Snippet contribution
Do you want to contribute and add your own snippets? Create an account and start sharing your information.
