accessing an enterprise custom field using SQL and the reporting D

[SharkTracker]

Does anyone have a simple sqL query that shows how to access an enterprise
custom field in the Reporting database. I have tried to follows some of the
SQL queries in some of the views but can not seem to get it to work.

 

[Rod Gill]

Hi,

In the Reporting database look at the Views already created for you. Look
specifically at the ones ending in _userview they have the custom fields
already appended automatically to their end (last columns).

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Does anyone have a simple sqL query that shows how to access an enterprise
custom field in the Reporting database. I have tried to follows some of
the
SQL queries in some of the views but can not seem to get it to work.
--
Sharktracker

__________ Information from ESET Smart Security, version of virus
signature database 4523 (20091019) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4523 (20091019) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Parth]

Hi,
Below
--TASK LEVEL CUSTOM FIELDS....
SELECT MD_PROP_ID,MD_PROP_NAME from MSP_CUSTOM_FIELDS WHERE
MD_PROP_NAME='SHIFT'

SELECT LT_STRUCT_UID AS CODE_VALUE,LT_VALUE_TEXT FROM
MSP_LOOKUP_TABLE_VALUES WHERE LT_UID
IN (SELECT LT_UID FROM MSP_LOOKUP_TABLES WHERE LT_NAME='SHIFT')

Here you just have to change....Shift to lookup table you have and Custom
field you have........in my case both are the same only....

I have executed above queries on PUBLISHED DATABASE.

Thanks

Parth

 

[Rod Gill]

Just be aware that Microsoft do not recommend using the Publish and draft
dbs. They reserve the right to change them for any hot fix or service pack.
So any update may break this code.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,
Below
--TASK LEVEL CUSTOM FIELDS....
SELECT MD_PROP_ID,MD_PROP_NAME from MSP_CUSTOM_FIELDS WHERE
MD_PROP_NAME='SHIFT'

SELECT LT_STRUCT_UID AS CODE_VALUE,LT_VALUE_TEXT FROM
MSP_LOOKUP_TABLE_VALUES WHERE LT_UID
IN (SELECT LT_UID FROM MSP_LOOKUP_TABLES WHERE LT_NAME='SHIFT')

Here you just have to change....Shift to lookup table you have and Custom
field you have........in my case both are the same only....

I have executed above queries on PUBLISHED DATABASE.

Thanks

Parth


__________ Information from ESET Smart Security, version of virus
signature database 4531 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Stephen Sanderlin [MVP]]

I suggest you take Rod's advice and use the _UserView views present in
the RDB.

--
Stephen Sanderlin, Project MVP
VP of Technology
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com