Insight / Assets recursive search

[Patrice Champet]

Hello,

Is there a way to write an IQL /AQL to get the whole hierarchy of objects of the same time linked between them by an attribute ?

For instance, it could be use with a User object where we store N+1 User only, to get the whole liste of superior in the hierarchy.

Exemple:

• John having Mary as N+1
• Mary having Klara as N+1

It's quite simple to get John N+1, with a search such as

 user having inR( "User" = John, refType in("Reports to"))

But what if I want the whole list of superior from John to the top of the hierarchy with an IQL /AQL ?

Any suggestion ?

Thanks ! 

[Dimitri Cools]

I'm looking for this as well... I think it's simply not possible ..like many other things

.. Those Assets and its functionality is WAY TO SIMPLE  to have some decent use in real world use cases !