Complex Report Criteria to Report back CN Task to CN Notice

[BrianToussaint]

We currently require that our CN Task number matches our CN Notice number.  The main reason is for reports that MFG runs against the CN number to get the Resulting Objects in PDF format for a meeting.  What I would like to do is type in the CN Notice number and get the Resulting Objects no matter what the CN Task number is that is associated with the CN Notice.  It works well if the numbers are the same, but if they get off, then the report doesn't work.  When this happens it takes a lot of time and work to get it all corrected, depending on when it was caught.  I am hoping that this is a simple join, but does anyone know how to do this?

[Marco_Tosin]

Hi Brian,

maybe this article could be useful for you about joining change objects.

https://www.ptc.com/it/support/article?n=CS106301

[BrianToussaint]

Thank you Marco for pointing out this article!  Hopefully this will get me where I need to be.

[Marco_Tosin · Accepted solution]

There's another article where you can see graphically all the joins between Change objects

https://www.ptc.com/en/support/article?n=CS268023

[BrianToussaint]

It is helping, but it isn't giving me the IncludedIn2 link between the two tables in 11.0.  I know that there was an extra area in 10.2 that allowed for these types of links.  I think I remember there were two different areas in the join section.

[BrianToussaint]

Starting over from scratch and not an old Report is helping.  I will try from scratch and see if I can get what I need.

Thank you for the links Marco!