Document Attributes Environment Attribute value (PW_DOC_DESCRIPTION) from SQL query

Hi all,

Just try to use the SQL query to read out the drawings in "Document Attributes" Environment for Attribute value (PW_DOC_DESCRIPTION).

I can read out the pdf files in "Rendition Attributes" environment for  Attribute value (PW_DOC_DESCRIPTION) from database table named "env_rendattr". What is the attribute database table name for Document Attributes please?

Thanks for your help.

Ritchie

 

Parents
  • Ritchie,  Each time you create an Environment, it creates a new table to store those Attributes.  However, the general document properties such as Name, Description and Filename are held in the DMS_DOC table.  The field names are O_ITEMNAME, O_ITEMDESC, and O_FILENAME.   Is that what you are looking for?

Reply
  • Ritchie,  Each time you create an Environment, it creates a new table to store those Attributes.  However, the general document properties such as Name, Description and Filename are held in the DMS_DOC table.  The field names are O_ITEMNAME, O_ITEMDESC, and O_FILENAME.   Is that what you are looking for?

Children
No Data