David Schmalzer
asked on
Indexing
Is there a way to set up indexing on a database to only index documents that are newer than a certain date?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think I can use that! Thanks, Heman.
You can also use the ftindex to look for documents modified or created since a certain date.
A full text search like this will return all new or modified documents since 1st december
([_CreationDate] > 12/1/2003) OR ([_RevisionDate] > 12/1/2003)
So instead of using the db.search as Hemantha proposes, use the ftsearch method : it's faster.
set notesdocumentcollection = db.ftsearch( Query$, options.... )
cheers,
Tom
A full text search like this will return all new or modified documents since 1st december
([_CreationDate] > 12/1/2003) OR ([_RevisionDate] > 12/1/2003)
So instead of using the db.search as Hemantha proposes, use the ftsearch method : it's faster.
set notesdocumentcollection = db.ftsearch( Query$, options.... )
cheers,
Tom
Let me check back with your later.
~Hemanth