Transferring ownership to container owners

SITI_BSD_(shellinfosysuser3_-_(deleted))

Hi,At present we move all docs owned by a user to a singular other user which is doable in a Livereport (update dtree and dtreeacl)However what I would like to do is to update the owner to be the folder owner of each object's container. (ie folder owners are responsible for their area hence they logically should inherit ownership).The problem happens when the folder is owned by the same account (or any number of folders above that) that you are trying to change ownership.So you need to be able to find the first container where the parentid is not the same as the user and assign that as the current objects parentid - whilst doing this for ALL objects owned by the user - hence 1 object 1 livereport is not an option.Can anyone enlighten me if this is possible in a Livereport and how? I can picture it using variables but alas my only avenue to make this change is via a Livereport.Thoughts so far on dtree only without taking into account said above problem (same theory should apply to dtreeacl and that would need to be run first to allow for dtree to know what to change the dtree.userid to):update dtree d1 set d1.userid = (select d2.userid from dtree d2 where d1.parentid = d2.dataid) where d1.userid = %1 and d1.parentid > 0Many thanks for any thought!