Archiving via a replica

Hi,

I'm writing an archive routine in script to remove all documents that haven't been modified in over a year. The problem is that I created a replica yesterday, I don't want to work on the live db. As a consequence of this the lastmodified property in script is giving yesterdays date. If you right click on an old document the modified date is the true modified date, and the 'modified in this file' is yesterdays date. Is there an easy way to access the first modified date through script? I'm using Notes 4.6

Thanks
srandrewsAsked:
Who is Participating?
 
floriangrimmConnect With a Mentor Commented:
bad news
no you cannot

but...
you can copy the file - you have stop the server (are you admin?)...


don't you replicate to any server?
if yes you may have a problem, but also a simple solution

create an field e.g. "lastsave" (date)
in the recalc-event you set the field to now
(FIELD lastsave := @Now;
@Success).
(Now you can set the field in an Agent
FIELD lastsave := @Modified;
SELECT @ALL)

now test the new field in your script.

if you often modify these documents, there is a problem --- replica and save conflicts...
{but you might help do test the field befor seting...
FIELD lastsave := lastsave;
@if(lastsave <= @Adjust(@Now;0;0;-7);
  @SetField("lastsave"; @Now);
  @Success);
@Success
)

i hope this helps....
bye Flori
0
 
srandrewsAuthor Commented:
Not what I was wanting to here! But I was expecting it. I don't want to modify 100,000 documents, which is how big the database is. I have just checked and @Modified returns the correct modified date so I'll use the Evaluate command in Script.

Cheers Flori
0
All Courses

From novice to tech pro — start learning today.