Description of how to find custom fields of projectserver

First, you can refer to my previous blog:

Http://www.cnblogs.com/olay/archive/2012/06/28/2568499.html

Similarly, I add a Custom Field "owner" to projectserver ",

In the published database, we can find the data in the DBO. msp_custom_fields table where md_prop_name is the "owner.

You can find the md_prop_uid, that is, the index of DBO. msp_custom_fields Based on the Data. All other data is marked with this field.

Then, in the msp_task_custom_field_values table, find md_prop_uid with the same value to find the value of this custom attribute,

The value of this custom attribute is stored in the text_value field.

The total SQL statement is:

Select B. text_value from DBO. msp_custom_fields as
Inner join DBO. msp_task_custom_field_values as B
On a. md_prop_uid = B. md_prop_uid
Where a. md_prop_name = 'owner'

In this way, we can easily find the value of the projectserver custom attribute.