Is there is any way to create a query for multi level relationship

[skrisnamoorthy]

Hi,

Is anyone know how to create a query for multi level relationship

For Eg:

Level : 1

Level : 2 (related Item)

Level : 3 (related Item)

Level : 4 (related Item)

How to retrive the list of Level 4 items from Level 1 (Using ID) from a Query?

Regards,

Shankar

[mrump · Accepted solution]

Hi Shankar,

unfortunately there is no way to receive this information using a query.

This is only possible using a report started for your level 1 item(s).

Note:

The relationship filter in the query designer only allows you to filter for "Level 1" items that have a relationship to "Level 2" item which fulfill certain criteria.

HTH Matthias

[KaelLizak]

Hello Shankar,

Matthias is correct:

• ​Not available because the functionality does not exist
• Reported to R&D as enhancement RFC 145864 via CS88090
• Please contact PTC Integrity Support if you wish to be associated with this enhancement request

Regards,

Kael

[VolkerEckardt]

Hi Shankar,

I did a lot of researched and developed already some add-on solutions in the area of tracing and relationship trees.

I am interested to know which use case is behind your question. What do you try to accomplish with such a complex query?

Volker