Skip to main content
B
bwilson-21-Visitor
1-Visitor
January 4, 2011
Question

Variance Affected objects

  • January 4, 2011
  • 4 replies
  • 970 views

Hi all,

I am trying to use query builder to create a report where I can enter the variance number and return among other things the affected objects. I am pretty sure this can be done. I just can't seem to figure out the join. Any thoughts would be greatly appreciated.

Thanks,

Brian

4 replies

A
AL_ANDERSON12-Amethyst
12-Amethyst
January 4, 2011
Try this.
S
ShaylynJoy1-Visitor
1-Visitor
January 10, 2011


Hi Brian/Albert,

I have written the SQL that Brian was talking about. I can pull in the number, name etc. as well as the affected objects. However, I can't seem to get this to work in the Report Manager. Have you tried to do this?

Thanks,

A
AL_ANDERSON12-Amethyst
12-Amethyst
January 11, 2011
The trick with something like affected objects is that you have to specify
what type of affected object you want to link to.

I did not look carefully at Brian's SQL, But here is an example for
objects attached to an ECR by the Relevant Request Data2 link. Other,
similar links can follow the same pattern. The Outer Join Against Change
Request in the From tab for Document will give CR's with and without links
to Documents. Without the outer join, you only get Change Requests with
links to Documents.




I only selected the CR and Doc numbers.

I ran this as HTML (with merging).

The results look like this.



You should be able to make the appropriate link and outer join for your
data (Variance and Affected Objects).

Al Anderson
Solar Turbines Incorporated






Shaylyn Joy <->
01/10/2011 08:03 AM
Please respond to
Shaylyn Joy <->


To
-
cc

Subject
[solutions] - RE: Variance Affected objects




Caterpillar: Confidential Green Retain Until: 02/09/2011




Hi Brian/Albert,
I have written the SQL that Brian was talking about. I can pull in the
number, name etc. as well as the affected objects. However, I can't seem
to get this to work in the Report Manager. Have you tried to do this?
Thanks,

Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription
Use of this email content is governed by the terms of service at:
S
ShaylynJoy1-Visitor
1-Visitor
January 12, 2011


Albert,

Thanks so much! I'm finally starting to get this to work.

Much appreciated.

- Shaylyn

Terms & ConditionsAccessibility statement