Audit of a Folder and all his SubObject

Marius_Däpp_(marius.daepp@unic.com_(Delete)_127473

HelloI want do a SQL Statement witch lock like this:Select AuditStr,AuditDate,UserID FROM les970.DAuditNew WHERE DataID = %1But it shot give me also the Audit of all SubObject'scan somebody Help me?Best Regards!Marius Däpp

Bhupinder_Singh

If you are using an Oracle database, then this might help:select * from DAuditNew DA where DA.DataID in ( select DT.DataID from Dtree DT start with DT.DataID = %1 CONNECT BY PRIOR DT.DataID = DT.ParentID )Ensure you run your own tests to determine accuracy/validity of the above on your system.- Bhupinder----------------------------------------------Bhupinder Singh, B.Math, B.Ed.Senior Systems Analyst, Information TechnologyOpen Text, Waterloo, Ontario, Canada----------------------------------------------