Solved

Indexing

Posted on 2003-12-01
4
254 Views
Last Modified: 2013-12-18
Is there a way to set up indexing on a database to only index documents that are newer than a certain date?
0
Comment
Question by:schmad01
  • 2
4 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
Comment Utility
Indexing is done on whole database. But I believe that there are few notes.ini parameters on server.

Let me check back with your later.

~Hemanth
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 500 total points
Comment Utility
Well I don't see any options for that, take a look at the ini parameters

http://www.drcc.com/A55711/ref/notesini.nsf/all?openview&jump&startkey=ft_

If you are looking for a way to extract only those docs which are newer than a certain date then use search method of the database

Set notesDocumentCollection = notesDatabase.Search( formula$, notesDateTime, maxDocs% )


0
 

Author Comment

by:schmad01
Comment Utility
I think I can use that!  Thanks, Heman.
0
 
LVL 15

Expert Comment

by:Bozzie4
Comment Utility
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
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now