UIB - display nested records from different tables

[romuduck]

Hello community

I have a flow where upon submitting a new RITM record, some tasks get created, themselves creating other records, ...

So basically, something like:

RITMxxx

- SCATSK123

    - taskABC

    - taskDEF

- SCATSK456

    - taskGHI

    - taskJKL

I was wondering what would the best approach in fetching and displaying all these child records which belong to different tables in a UIB page? how should I construct the datasource?

Thanks a lot for your help

[romuduck]

I forgot to mention that every child record has a reference to its parent.

So I need to perform:

- get sctaskXXX records from sctask table where parent = RITMxxx

- for each above record, perform:

   - get task records from task table where parent = SCTASKxxx

but unsure how to do it properly in UIB

thanks