Live Report for Activity within a Folder and its Sub-Folders?

Karen_Morley

Has anyone written a report that will provide activity within a folder AND its' subfolders? Just need to be able to display create, fetch and download date by users.I have the report for a single folder but need to be able to capture sub-folders in one report rather than doing individually.We are using Livelink 9.2 (database is Oracle)

Simon_(INACTIVE)_Scoble

I have used the following to do more or less that (with the addition of a selectable date range). This SQL will only work for Oracle. You will need to make some slight modifications to get your groupings, and you can add additional filtering on auditnew to restrict to the events you require.Hope it works for you.Simon-------------------------------SELECT t.dataid "Doc ID", t.name "Document name", k.lastname "Last Name",k.firstname "First Name", a.auditstr "Event", a.auditdate "Date"FROMDAuditnew a, DTree t, kuaf kWHERE(t.dataid=a.dataid) AND (a.dataid in (SELECT dataId from dtree start with dataId in (%2) connect by prior dataid=abs(parentid) ) )AND(TRUNC(a.auditdate) between %3 AND %4)AND(k.id = a.PERFORMERID)GROUP BY t.name, t.dataid, k.lastname, k.firstname, a.auditdate, a.auditstrorder by t.name, k.lastname ASC-------------------------------%1 = Filter Document%2 = User Input 1 Container%2 = User Input 2 Date (select start date)%3 = User Input 3 Date (select end date)