Three Enterprise Global Templates and Outline_COde Table

[CQ]

Somehow, on our system, we have three Enterprise Global Templates.
Everything is working normally and in the table, one of them clearly is
marked as "inactivated enterprise template" and another one is the active
template (I have no idea about the third one - it doesn't show up that i can
find). Everything seems to work fine. EXCEPT - reporting. I have a number
of reports that use the "Outline_Codes" table, and when I link to it, it
comes up with three results for every task or every code field or whatever I
link to it. Putting in a "don't use this Proj_ID" doesn't work since
everytime the Global is modified, it gets a new "PRoj_ID". So, how do I get
to report out of Outline_Code without getting triple information on
everything? And, since these are memo/ntext/text fields, just doing a
"summary" or "group by" doesn't work either.

 

[Scott Wagner [MCP, MVP]]

CQ,

In this instance you are probably using the mp.PROJ_TYPE = 2 for your
queries. If you have 3 that are showing active you have two choices.
1) Delete the old one (Backup the database first in case there are issues)
2) Get the ID of the current Global and add that to the query.

Hope that helps!


Have a great day!

Scott M. Wagner [MCP, MVP]

 

[CQ]

Thanks Scott, I have tried that to some degree, the issue I encounter is
that the ID of the Global Template keeps changing. If I make a change to the
Global then it gets a new Proj_ID - that isn't static. Also, the
Outline_Code table doesn't have the option of a Proj_TYPE. The Outline_Code
table seems to give you every link....for example, if I open the Outline_Code
table (even when hooked to MSP_Projects via the Code_Fields table) I get this
result - which is the three current Global Template ID's, with the 6 options
listed.
PROJ_ID OC_FIELD_ID OC_NAME
752 188744589 Active
752 188744589 Cancelled
752 188744589 Completed
752 188744589 On Hold
752 188744589 Proposed
752 188744589 New
755 188744589 Active
755 188744589 Cancelled
755 188744589 Completed
755 188744589 On Hold
755 188744589 Proposed
755 188744589 New
756 188744589 Active
756 188744589 Cancelled
756 188744589 Completed
756 188744589 On Hold
756 188744589 P roposed
756 188744589 New

CQ,

In this instance you are probably using the mp.PROJ_TYPE = 2 for your
queries. If you have 3 that are showing active you have two choices.
1) Delete the old one (Backup the database first in case there are issues)
2) Get the ID of the current Global and add that to the query.

Hope that helps!


Have a great day!

Scott M. Wagner [MCP, MVP]

Somehow, on our system, we have three Enterprise Global Templates.
Everything is working normally and in the table, one of them clearly is
marked as "inactivated enterprise template" and another one is the active
template (I have no idea about the third one - it doesn't show up that i
can
find). Everything seems to work fine. EXCEPT - reporting. I have a
number
of reports that use the "Outline_Codes" table, and when I link to it, it
comes up with three results for every task or every code field or whatever
I
link to it. Putting in a "don't use this Proj_ID" doesn't work since
everytime the Global is modified, it gets a new "PRoj_ID". So, how do I
get
to report out of Outline_Code without getting triple information on
everything? And, since these are memo/ntext/text fields, just doing a
"summary" or "group by" doesn't work either.