Get folder path with r_version_label

Sri_Kumaran

SELECT distinct f.r_object_id, fr.r_folder_path, f.r_version_label
FROM dm_sysobject_r sr,dm_folder_r fr, fdk_document f
WHERE sr.i_position = -1 AND
      fr.r_object_id = sr.i_folder_id AND
      fr.i_position = -1 AND
      f.r_object_id = sr.r_object_id AND
      f.i_latest_flag=1 AND
      f.i_is_deleted = 0 AND
      f.r_object_id IN (SELECT r_object_id
                        FROM fdk_document
                        WHERE lower(f.document_unit) LIKE 'abc%')
ORDER BY fr.r_folder_path,f.object_name DESC
enable(ROW_BASED)

NOTE: r_version_label is one of the repeating attributes of fdk_document (dm_document)

Output of above code:

f.r_object_id   fr.r_folder_path   f.r_version_label
-------------        ----------------        -----------------
xxxxxxxxxxxx    yyyyyyyyyyyyyyy    1.0
xxxxxxxxxxxx    yyyyyyyyyyyyyyy    APPROVED
xxxxxxxxxxxx    yyyyyyyyyyyyyyy    LATEST
xxxxxxxxxxxx    yyyyyyyyyyyyyyy    CURRENT

Expected output:

f.r_object_id   fr.r_folder_path   f.r_version_label
-------------         ----------------       -----------------
xxxxxxxxxxxx    yyyyyyyyyyyyyyy    1.0,APPROVED,LATEST,CURRENT

christopher.imes

Please consider moving this question as-is (no need to recreate) to the proper forum for maximum visibility.  Questions written to the users' own "Discussions" space don't get the same amount of attention and can go unanswered for a long time.

You can do so by selecting "Move" under ACTIONS along the upper-right.  Then search for: "Documentum" and select the first result that appears.  This will relocate it to the Developer Network space of the Documentum community.

Documentum

For further guidance on engaging with the communities for Documentum and related products, please refer to the

IIG Communities Getting Started Guide.