I need to develop a scheduled search agent, which will search for the documents, based on a saved search criteria document and send number of results in a mail. Means agent will:
1. First pick the document in which search criteria (field specific) is stored
2. Create search query from saved search criteria
3. Get collection of the documents returned by search
4. Finaly send the number of documents returned by search (collection.count) in a mail to me
I need to know which method out of db.FTsearch and db.Search, will be most suitable for the scenario. My database is indexed.
What are the basic diffrences between two, why Lotus given two search metods, what are limitations of two (e.g. in terms of max number of documents returned, I may get more then 5000 docs in search result, and any other), and what are adwantages of one over other.