Report for link between Process Plan and Standard operations

[AA_10748298]

 How to create a Query Builder report between process plan and standard operations  

By this report i should be able to know Which standard operations are associated with which process plans.

I am not sure which join should be used between them in query builder. Can anyone help me on this ?

Class name for process plan :-  com.ptc.windchill.mpml.processplan.MPMProcessPlan

Class name for standard operations :- com.ptc.windchill.mpml.processplan.operation.MPMOperation

[Marco_Tosin · Accepted solution]

If you want to know which tables you can link to a table you have selected, you can use the right mouse button.

Click on the table and select add table and join.

Then choose from the list the one you are interested in.
Obviously the list consists only of the tables that can be directly linked to the one you selected