Document Attributes Environment Attribute value (PW_DOC_DESCRIPTION) from SQL query

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

Take a look at the dms_tab table.  It will give the table names for each of the environments.

Something like this should work.

SELECT * FROM dms_tabs WHERE o_tabno = (SELECT o_tabno FROM dms_env WHERE o_envname LIKE 'Simple')

Take a look at the dms_tab table.  It will give the table names for each of the environments.

Something like this should work.

SELECT * FROM dms_tabs WHERE o_tabno = (SELECT o_tabno FROM dms_env WHERE o_envname LIKE 'Simple')