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
  • Hi Dean,

    Really appreciated your reply. Yes I agree with you about the each Environment will create a new table (I guess the same as what you said). Also you are correct the O_ITMEDESC is the description in the common tab in ProjectWise. But I struggle to read out the description inside of the environment using SQL query. eg. environment name is "Rendition Attributes" then database table name is "env_rendattr". But what or how can I find out the database table name if environment name is "Document Attributes". If I know the database table name, I can do select * from <tablename> to find out all columns in the table then to try out the one for attributes.

    Also which table has the attribute for "foldername" please?

    If there is a ER diagram for ProjectWise database?

    Thx.

    Ritchie

Reply
  • Hi Dean,

    Really appreciated your reply. Yes I agree with you about the each Environment will create a new table (I guess the same as what you said). Also you are correct the O_ITMEDESC is the description in the common tab in ProjectWise. But I struggle to read out the description inside of the environment using SQL query. eg. environment name is "Rendition Attributes" then database table name is "env_rendattr". But what or how can I find out the database table name if environment name is "Document Attributes". If I know the database table name, I can do select * from <tablename> to find out all columns in the table then to try out the one for attributes.

    Also which table has the attribute for "foldername" please?

    If there is a ER diagram for ProjectWise database?

    Thx.

    Ritchie

Children