1

I am very new to lotus notes and java. I am trying to get all documents which are modified by specific time. I can not use getallmodifieddocuments because , notes version R5.

I am trying to get it as follows:

String query = Select Form = Protocol & ( last value from $revision ) > input datetime stamp

DocumentCollection dc = db.search ( query );

Then get all documents and process them.

Is it possible.

  1. I can not get to $revision value to get print by getitemvaluestring ( $revision )
  2. Is query even possible to implement?

I will appreciate if any other way !

DontVoteMeDown
  • 21,122
  • 10
  • 69
  • 105
Prajakta
  • 27
  • 1
  • 3

1 Answers1

3

The Notes formula language has a built in formula for accessing the last modified date of a document: @Modified

Or if you have a reference to the document from Java, the getLastModified() method should get you that information.

Your query could be:

String query = "Form = ""Protocol"" & @Modified > @TextToTime(""1/1/1970"") "
Ken Pespisa
  • 21,989
  • 3
  • 55
  • 63
  • Thanks so much. I dont want to use getlastmodified() , i dont want to get to every document and perform that comparison. Just want to select modified time over input time stamp. Thanks for your help that query helped. – Prajakta Jun 21 '13 at 22:11
  • 1
    @Prajakta, when it's done in the query, you arne't getting each document and then doing the comparison. – David Navarre Jun 22 '13 at 18:02