cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Complex Report Criteria to Report back CN Task to CN Notice

SOLVED
BrianToussaint
Tanzanite

Complex Report Criteria to Report back CN Task to CN Notice

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?

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Complex Report Criteria to Report back CN Task to CN Notice

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

 

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

 

Marco

View solution in original post

5 REPLIES 5

Re: Complex Report Criteria to Report back CN Task to CN Notice

Hi Brian,

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

 

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

Marco

Re: Complex Report Criteria to Report back CN Task to CN Notice

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

Re: Complex Report Criteria to Report back CN Task to CN Notice

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

 

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

 

Marco

View solution in original post

Re: Complex Report Criteria to Report back CN Task to CN Notice

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.

Re: Complex Report Criteria to Report back CN Task to CN Notice

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!

Announcements