How to make a recursive action
Application Type

Hello , I want to do a recursive action that calls an sql ( input = entity Id , output= list of entities) and then the list of results should be iterated again and so on , until the sql output is empty. Do you have any idea how to implement this in Outsystems?

This is the action I want to make recursive:


I can not understand your question correctly.

If you pass entity ID then only one record will come as output. (filter by ID column).

If you can add an example it would really help.

If you are using Advanced SQL, why dont you do it in SQL only. You can search for Hierarchical data query.

What DB (Oracle/SQL) you are using. let me try if I can get something for you.