Forum Discussion

NicoD's avatar
NicoD
Ideator I
5 months ago

Make the use case of 2 articles to find a common parent article

Hello community, how can I find a parent article from two child articles using a query builder definition? I'm still searching but can't find much on the subject. Thanks again. I work with ARAS 22

6 Replies

  • Hi there,

    You should be able to build a query definition where you have a top level parent article with duplicated relationships to child articles like the example below (I'm using Part BOM relationships for simplicity but it should work the same with your custom data model).

    Each of these child articles can have separate conditions, and then you can include a condition on the parent article where you specify that it has at least one instance of each child article like the example below.

    Let me know if this works for your use case.

    • NicoD's avatar
      NicoD
      Ideator I

      Hello, I'll test it and get back to you soon. Thank you.

      • NicoD's avatar
        NicoD
        Ideator I

        My basic requirement is to be able to find a final parent article from two shared child articles. I'm in the first child article with my related TGV. Example, I am in the bearing article and I enter in variable the name of the article 2 a shaft and I want to find the motor which uses its 2 components).I created a variable to dynamically enter the article names (Part_1 and Part_2). Here's my modified query. The result is incorrect; I must have made a mistake in my query. Thanks.