12-Amethyst

Solved

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

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

Best answer by avillanueva

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

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

Answer

23-Emerald I

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

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

18-Opal

@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.

Author

12-Amethyst

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

Sign up