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

Parents
  • 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.

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

  • オフライン in reply to NicoD

    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.

  • オフライン in reply to NicoD

    Hello, in a query builder is it possible to have 2 distinct branches, which would allow to have one branch for article 1 and the other for article 2. Thank you

  • オフライン in reply to NicoD

    Hello community, I found it and I'll give you the query definition.

    In summary, on the same article level, I can search for 4 articles common to a parent article.

    Thanks Christopher to your help. 

  • オフライン in reply to NicoD

    Hello, is it possible to perform a multi-value search in the search variable of the tree grid I created? Currently, I can search multiple columns, but only one value at a time. My search method is *123*. I tried *123*|*456*, but it doesn't work.
    Thanks.

Reply Children
No Data