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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

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

skrisnamoorthy
1-Newbie

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
mrump
14-Alexandrite
(To:skrisnamoorthy)

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

View solution in original post

3 REPLIES 3
mrump
14-Alexandrite
(To:skrisnamoorthy)

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
14-Alexandrite
(To:mrump)

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


Kind Regards,
Kael Lizak

Senior Technical Support Engineer
PTC Integrity Lifecycle Manager

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

Top Tags