Need a LiveReport which shows me documents older w/o a new version in 3 yrs

Hello,I need a livereport that will do a recursive search on a given folder and return the parent folder, folder, and file name of documents that have not had a new version in 3 years. The trick is we have opted to set permission modifications to change the modify date, so the modify date in the dtree table is not correct.Thanks,Jeremy

Find more posts tagged with

Comments

Appu_Nair

Why would you not look into the schema definition of these 4 dates FileMDate,FileCDate & VerMDate&VerMDate.An article by Bhupinder into what all those dates are in the KB.I am sure one of these dates don't get affected by your permssions push I could be mistaken.Docid in dversdata is dataid in dtree.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

I would highly recommend going through the reports provided in the following thread, at least as a starting point:

https://knowledge.opentext.com/go/2463201

Let me know if that helps.

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, February 12, 2009 9:43 AM
To: eLink Recipient
Subject: Need a LiveReport which shows me documents older w/o a new version in 3 yrs

Need a LiveReport which shows me documents older w/o a new version in 3 yrs

Posted by wilene03admin (Romondo, Jeremy) on 2009/02/12 09:39

Hello,

I need a livereport that will do a recursive search on a given folder and return the parent folder, folder, and file name of documents that have not had a new version in 3 years. The trick is we have opted to set permission modifications to change the modify date, so the modify date in the dtree table is not correct.

Thanks,

Jeremy