Query Builder Joins

[srector]

Can anyone point me to where PTC has "hidden" the definitions of the various Query Builder Joins?

I'm trying to tweak an existing report, but I feel a little like I am "Throwing Darts in the Dark".

I've looked in the Bus Admin & Windchill Customizer guides, and either I'm hopelessly blind, or the information isn't in there.

Thanks to all,

Steve

[AL_ANDERSON]

Go to PTC's support documentation.

Look for the latest HTML Rose Model for download.

Download that.

It is not perfect, but if you can read the UML models there, then you can
easily translate those model associations into Query Builder joins.

There is also some trial and error involved, as well, when you have a
number of options and you are not entirely sure which join to use.

Once you get proficient, start playing with outer joins. The use of outer
joins makes things even better (i.e. you can get all PRs with or without
associated ECRs including the attacked ECR number for PRs attached to
ECRs, etc.).

Al Anderson







Steven Rector <steven.rector@drs-sts.com>
09/09/2010 09:47 AM
Please respond to
Steven Rector <steven.rector@drs-sts.com>


To
-
cc

Subject
[solutions] - Query Builder Joins




Caterpillar: Confidential Green Retain Until: 10/09/2010



Can anyone point me to where PTC has "hidden" the definitions of the
various Query Builder Joins?
I'm trying to tweak an existing report, but I feel a little like I am
"Throwing Darts in the Dark".
I've looked in the Bus Admin & Windchill Customizer guides, and either I'm
hopelessly blind, or the information isn't in there.
Thanks to all,
Steve

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: