Skip to main content
skrisnamoorthy1-Visitor
1-Visitor
Sep 29, 2014 9:07 PM UTC
Solved

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

    mrumpAnswer
    16-Pearl
    Sep 30, 2014 9:01 AM UTC

    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 in thread

    3 replies

    mrump16-PearlAnswer
    16-Pearl
    Sep 30, 2014 9:01 AM UTC

    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

    Translate
    KaelLizak16-Pearl
    16-Pearl
    Oct 3, 2014 3:07 PM UTC

    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

    Translate
    VolkerEckardt17-Peridot
    17-Peridot
    Oct 5, 2014 6:20 PM UTC

    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

    Translate
    Terms & ConditionsAccessibility statement