How to select the custom attributes value?

Options
Dat
Dat
edited December 12, 2008 in Documentum #1

Could some body please tell me how to seelect the custom attributes?  I am using

SELECT * FROM dm_sysobject

WHERE FOLDER ('/XXXX/YYYY') and r_object_type = 'ZZZZZZ'

ORDER BY r_object_type, object_name

to select all documents with document type ZZZZZZ from this folder and I am expecting to see all attributes belong to this document type, but I can only see the default attributes (i.e. title, subject ...), if I add 'Authors' to the select statement then I can see the 'Authors' in the results. 

What do I need to add to the select statement to see my custom attributes?

Comments

  • K-Mac
    K-Mac
    edited December 12, 2008 #2
    Options

    Change the DQL:

    SELECT * FROM ZZZZZZ

    WHERE FOLDER ('/XXXX/YYYY')

    and you'll have access to the custom attributes of type 'ZZZZZZ'

Categories