Create a multi level ''where used'' report for CAD

[MR_10810161]

I would like to create a report that finds all the CAD Models in which the specified model is used.

For a single level I already have one report template in attachments.

I tried to edit the xml directly but it did not help and in the Builder I do not have much experience

Can anyone help me to modify it to be multil evel?

I am using: Release: 12.1.2.15

Thanks

BR

[avillanueva · Accepted solution]

What you need is a recursive query. Not to complex to do in SQL but here is what I found with Query Builder:

https://www.ptc.com/en/support/article/CS361660?source=search

https://www.ptc.com/en/support/article/CS73216?source=search

All signs point to file an enhancement or not possible using query builder.

[d_graham]

@MR_10810161 ,

I agree with @avillanueva .

This is a no can do with Query Builder unless you take advantage of Query Builder's "Java Method" functionality.

With Java Method functionality you can do anything including a multi-level where used.

[MR_10810161]

Thank you for your contribution, I will try to get this through a customisation ..