In Dversdata what is difference between following fields?

Hi,What is the difference between the fields: FileMDate and VerMDate in the table DVersData?

Find more posts tagged with

Comments

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

Message from Olson, Leonard <<A HREF="mailto:len.olson@rgsinc.com">len.olson@rgsinc.com> via eLink

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

According to the Schema, FileMDate is the file's modification date and VerMDate is the last date/time that the version was modified.

You might try creating a test report with both columns, and check to see which one is most appropriate to your purpose --see what happens to the dates when you change permissions, add a version, change attributes & what have you. Then just use the one you want in your production report.

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, February 13, 2004 1:08
To: eLink Recipient
Subject: In Dversdata what is difference between following fields?

In Dversdata what is difference between following fields?

Posted by DeloitteAdmin on 02/13/2004 01:05 AM

Hi,

What is the difference between the fields: FileMDate and VerMDate in the table DVersData?

DeloitteAdmin_(Delete)_2707331

HI,The directory structure is something like this :Main Folder - Folder - Doc - Folder - Doc - Doc - FOlder - Folder - Doc - Doc - FolderThat isnt the exact structure but as you can see there are docs within folders etc..what I need to do is get a list of all Documents that have been modified since a certain date within the Main FOlder..how do I do this?

jamespate

A SQL statement like this will return documents modified in the last 7 days under folder:SELECT PARENTID,DATAIDFROM DTREEWHERE SUBTYPE=144AND MODIFYDATE>SYSDATE-7START WITH DATAID=

CONNECT BY PRIOR DATAID=PARENTIDThis works on Oracle 8i for Livelink 9.1.0.3NB. it does not traverse Project Workspace volume boudaries as the parent child relationship is handled differently.

jamespate

Have read more of this thread now - gets trickier.I am trying to solve this myself as part of a Quality Management System.I have Project Workspaces with the prefix "QMS". I run the previous query against each to determine which project have new or updated documents.It does pick up false positives (where the permissions have been modified for instance), but I could not use VERCDATE because some documents are moved in the folder from elsewhere in Livelink - these have an old VERCDATE but are new to the QMS area!The thing I haven't tackled yet is where people move entire folders into the area I'm monitoring. In this case there is NO RECORD of any changes to any sub-folders or documents.I use ColdFusion to run scheduled queries and generate web pages and/or emails of results. Using this I can run a top level query then run sub-queries as I loop over the recordset. So the next thing to do would be to identify any new "folder" objects and report that all sub-items are new. If there are any ColdFusion enthusiasts out there, I have attached my cfm page.