Outline Codes - How to display from External query tool

[chris kirch]

I am trying to build a report displaying my resources and the resource role
they have been given. I am having difficulty in getting the results I am
looking for. I have attempted to query from the following tables:


MSP Outline Codes
MSP View Resource Enterprise - In this one I found a field called :
Resourceenterpriseoutlinecode1Id. I tried to pull that with OC Name and OC
description from the MSP Outline Code table using Code UID as a key.
MSP Resources

Anyone know the magic formula?

 

[Brian Tkatch]

I am trying to build a report displaying my resources and the resource role
they have been given. I am having difficulty in getting the results I am
looking for. I have attempted to query from the following tables:


MSP Outline Codes
MSP View Resource Enterprise - In this one I found a field called :
Resourceenterpriseoutlinecode1Id. I tried to pull that with OC Name and OC
description from the MSP Outline Code table using Code UID as a key.
MSP Resources

Anyone know the magic formula?

I have no idea what you want, but i thought i'd try to help anyway.
I'm still learning this stuff, so i'm mostly feeling in the dark.

Basically, i was just writing a query to find all Outline codes
associated with some projects, and came up with this:

SELECT DISTINCT
SubString(MSP_Outline_Codes.OC_CACHED_FULL_NAME, 1, 255)
FROM
MSP_Conversions,
MSP_Code_Fields,
MSP_Outline_Codes
WHERE
-- Get the id for the projects enterprise field.
MSP_Conversions.CONV_STRING = 'Task Enterprise Project
Outline Code1'
-- Associate Code_Fields to get CODE_UID and PROJ_ID.
AND MSP_Code_Fields.CODE_FIELD_ID = MSP_Conversions.CONV_VALUE
-- Associate MSP_OUTLINE_CODES
AND MSP_OUTLINE_CODES.CODE_UID = MSP_Code_Fields.CODE_UID
AND MSP_OUTLINE_CODES.PROJ_ID = (SELECT MAX(PROJ_ID) FROM
MSP_PROJECTS WHERE PROJ_TYPE = 2)

B.