Query Builder Join Question

[pwilliams-3]

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]

[pwilliams-3]

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 [

[rstav]

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

[MikeLockwood]

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]

[MikeLockwood]

Oops - screen capture corrected below.

From: Lockwood,Mike,IRVINE,R&D

[AL_ANDERSON]

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

[AL_ANDERSON]

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