Skip to main content
S
skrisnamoorthy1-Visitor
1-Visitor
September 29, 2014
Solved

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

  • September 29, 2014
  • 2 replies
  • 1931 views

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

    Best answer by mrump

    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

    2 replies

    M
    mrump16-PearlAnswer
    16-Pearl
    September 30, 2014

    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

    K
    KaelLizak16-Pearl
    16-Pearl
    October 3, 2014

    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

    V
    VolkerEckardt17-Peridot
    17-Peridot
    October 5, 2014

    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

    Terms & ConditionsCookie settingsAccessibility statement