Solved

Indexing

Posted on 2003-12-01
4
257 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
ID: 9851347
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
ID: 9851426
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
ID: 9852066
I think I can use that!  Thanks, Heman.
0
 
LVL 15

Expert Comment

by:Bozzie4
ID: 9866200
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Encrypted Mail message in a NSF 10 30
Lotus notes email code 2 200
Lotus notes VB code 4 208
Inconsistent date field in Lotus Notes 6 93
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 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