Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Perform additional steps depending on a value / variable

Hi all

 

I have a tricky task. I am building a hierarchy based on a parent/child table. Unfortunately, I do not know how many levels the hierarchy will have. And even worse, it's subject to change from time to time.

 

So what I would like to do is query the parent/child table as long as necessary. E.g. if I find out that in level 3 there will not be any more children, the next steps should not be performed.

 

Is that possible?

 

How?

 

Thanks

 

Christian

Need Help

4 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    I'm not getting clear from your requirement. But in model view, you can create hierarchy easily.

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi

     

    I am sorry, that does not help. What I want to do is perform additional steps in the data source gathering depending on informations from that data source.

     

    Simple example: 

    I am getting data from a source which is a list of all bosses. I then want do see their direct reports. And for them, again the direct reports. And this should be done as long as there are direct reports.

    The reason why the classical hierarchy does not work is that there might be direct reports with more than 1 boss and the hierarchy does not come in columns, but in rows...

     

    Hope this is more clear now.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I think this is still not what I am looking for. Forget about the hierarchy options.

       

      This is more about performing additional steps when querying the data. And about performing steps depending on a given value.