I think this should be possible by querying the DAuditNew table on the DataID column and using Oracle's "connect by prior" command to start with the dataID of the parent folder. An example of using connect by prior in general is provided below:
Obtaining the path of an object in the DTREE table:
select DataID, Name, SubType from DTREE where DataID in ( select DataID from DTREE start with DataID = 4798 CONNECT BY PRIOR parentID = DataID )
The above query, in a sample Livelink test instance yielded the correct path for an alias as:
DATAID NAME SUBTYPE
2000 Enterprise 141
2315 Customers 0
3517 Pharmaceutical 0
4798 Good Document Alias 1
...i.e. "Good Document Alias" is in the folder "Pharmaceutical" which is in the folder "Customers" which is in the Enterprise Workspace.
The following query may provide the information you are looking for:
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 )
...replacing XXXX with the numeric DataID of the parent folder for which auditing of child objects is desired.
The above query, built as a LiveReport that prompts the user to select the parent folder, is attached.
Attachment: Edit DAuditNew - folder events including children.mht
Ensure you test the report for validity yourself, as I cannot make any guarantees with respect to complete accuracy of audit information exposed by it.
Let me know if that helps...
- Bhupinder
----------------------------------------------Bhupinder Singh, B.Math, B.Ed.Senior Systems Analyst, Information TechnologyOpen Text, Waterloo, Ontario, Canada----------------------------------------------
