Forum Discussion

NicoD's avatar
NicoD
Ideator I
6 months ago

Propagate a filter in a query definition

Hello, in a query definition, I use the use case of an article to bring up its parent articles.

I would like to be able to filter any level from the $class_morpho parameter which corresponds to [Morphological class].

At each node I defined a condition.

But as soon as it looks for a specific morphological class, it looks at the first level of kinship and if the value does not match and displays nothing while at the last level the value exists.

In the aras innovator 22 Query Builder Guide doc, there is a notion of filter propagation, but after many attempts I can't find it, my approach must not be correct.

or

Thank you for any help you can provide.

2 Replies

  • AngelaIp's avatar
    AngelaIp
    Ideator I
    6 months ago

    First at all: Do you add all the needed levels manually for a reason? Have you seen that there is an option for "Reuse Query definition" that is intended for multilevel queries? (I don´t know the correct english term). 

    Regarding filtering: Multilevel filtering is something that I hope Aras one day finds a better solution.

    This is what I use right now. I added one additional level for the top level and a repeating structure for the other levels. This exludes the top level from the filtering. Does it work great? Not really. The filter just hides the content, but don´t removes the nodes completly.

    • NicoD's avatar
      NicoD
      Ideator I
      6 months ago

      Hello and thank you Angela, yes I know this "Reuse Query definition" function it's the method I used initially, but I couldn't display only the "morphological class" of the last level parent articles. So I tried to make a more detailed structure and create a parameter per level "[Morphological class] like $class_morpho_N1 for level 1, [Morphological class] like $class_morpho_N2 for level 2 etc. To do a selective search by level, this solution is not necessarily the easiest. The goal of my query is to be able to make like excel a filter on a column and to display only the chosen value, and I don't want to export excel but use aras in all its features. The ideal function would be not to put a filter in the query to retrieve all the articles but to be able to activate a filter in the tree grid view as in a search of the main article grid, and I don't know how to do it yet. Thank for your help.