Skip to main content
P
pwilliams-313-Aquamarine
13-Aquamarine
April 13, 2012
Question

Query Builder Join Question

  • April 13, 2012
  • 6 replies
  • 3011 views
In Query Builder, what table links EPM Documents to WTParts using the various link types? Or is there 1 table per link type?


Patrick Williams | Engineering Systems | o: 616.698.3766 | c: 616.947.2110
[cid:image001.jpg@01CD1986.3B8E5C70]

6 replies

P
pwilliams-313-AquamarineAuthor
13-Aquamarine
April 16, 2012
Thanks for the help. Attached is a report from WTPart to EPMDocument including the family table values. Also there is a query to get downstream MPMLink parts from Design view WTParts.

Patrick Williams | Engineering Systems | o: 616.698.3766 | c: 616.947.2110
[cid:image001.jpg@01CD1BC5.3C102250]

From: Lockwood,Mike,IRVINE,R&D [
R
rstavish1-Visitor
1-Visitor
August 3, 2012
Query Builder gurus,

I have an existing report that I created that summarizes all the tasks of a workflow. I have been asked to add the instructions from the workflow tasks.

Does anyone know which attribute to add to the query to use to display the instructions in the report?

We are using Windchill 9.1 M060.

Thanks
Rich

Richard Stavish
Pro/E System Administrator

[cid:image001.jpg@01CD7152.76685B60] [cid:image005.jpg@01CD7160.D2A748B0] <">http://www.linkedin.com/company/sargent-aerospace-&-defense> [cid:image007.jpg@01CD7160.D2A748B0] <">https://twitter.com/#!/SargentAero>

E-mail:
Office:
Fax:
Mobile:

RStavish@sargentaerospace.com
520-744-1000 x4570
520-744-7529
520-437-5811
M
MikeLockwood22-Sapphire I
22-Sapphire I
August 3, 2012
Attached report shows all info of interest for all Workflow Activities from a give workflow template.
Finding how to create these reports for workflow templates has allowed us to greatly improve our efforts for workflow templates. It's very helpful to be able to see all info for a template in one place w/o drilling down into each one. We have other reports that allow listing all code and other things.

Example for OTB workflow template:
[cid:image002.png@01CD7164.A09092B0]

[cid:image001.png@01CD7164.EEBCC7B0]

[cid:image003.png@01CD7164.EEBCC7B0]

M
MikeLockwood22-Sapphire I
22-Sapphire I
August 3, 2012
Oops - screen capture corrected below.

From: Lockwood,Mike,IRVINE,R&D
A
AL_ANDERSON12-Amethyst
12-Amethyst
August 3, 2012
Try the "instructions" on the WfAssignedActivity linked via the
ActivityAssignmentLink to the WfAssignment linked via the WorkItemLink to
the WorkItem, as shown in the 9.1 object model, below.



Al Anderson




A
AL_ANDERSON12-Amethyst
12-Amethyst
August 3, 2012
Actually, you need links to the WfProcess linked to the activity. In that
case, these links will work from the WfProcess class.


The WfProcess is a WfContainer that is linked to the WfAssignedActivity
that has the "instructions" attribute via the ProcessStepLink because it
is a "WfActivity."


Al



Terms & ConditionsAccessibility statement