What is the best way to do the following- Gather all documents with a specific name
- search through all of those documents for text inside of a specific fields’ text
I know that I can use document collection to gather a set of documents, but how can I single out documents with specific names?
Once I have that collection of documents how can I search through one specific field for text that that matches (more like a LIKE command in SQL)
I’ve looked on the internet for example, but nothing really hits what I am trying to do.
Thanks for the help!
-Kris
Subject: notesdatabase.search
It sounds like you’re wanting to get this collection within script, to do something with it there. I would think you’d want to use:
Set notesDocumentCollection = notesDatabase.Search( formula$, notesDateTime, maxDocs% )
The Designer Help will give you a good intro. One of their examples seems similr to what you want:
searchFormula$ = {Form = “Project” & ReminderDate = @Today}
Set collection = db.Search(searchFormula$, Nothing,0)
Subject: Search Doc
I did read that from the docs. I have a field that is a summary field. Will ideaSummary = “Test” give me a result for a doc that has an ideaSummary of “I some to test something sooner” or does ideaSummary have to equal “Test”?
Thank you for your help.
-Kris
Subject: You might be better off with a full-text search
FTSearch method, use the query syntax described in the user help. Look for “Refining a search query using operators”.