Live report to find locations of all files under a folder.

[balakumar86]

Hi All,

I need a report which would find locations of all the files under a specific folder. The input is object id of that folder.

I have written the following query
select d.name, a.value1, d.subtype from dtree d, dauditnew a where d.dataid=a.dataid and d.subtype not in(0) and a.auditstr='Create' and d.dataid in (select dataid from dtree start with dataid in xxxxxx connect by prior dataid=parentid) order by d.name

This will work, if the document has been created in a location and not moved to some other location. If the document has been moved to any other location, then it would give a wrong value.

Any idea how i can correct it.

Regards,
Bala

 

[ggriffit]

Given the way Livelink organises its data it the DTREE table you can only see the "current" tree structure in relation to any given node.

It may be possible to use the DAUDITNEW table as that will store the source and the destination node ids, so if you are auditing MOVE's then you may be able to use that.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/