FTSearch question

HCL Domino Domino Forum
1

Hello,

I’m trying to write a small agent using FTSearch however I need FTSearch to qualify for two citerias:

In the domino designer help I have found this example:

Set collection = db.FTSearch(“alpha OR beta”,0)

and I’m trying now to make it work with a variable and a string. However I just can’t figure out what code I need.

Dim classes As Variant

Dim collection As NotesDocumentCollection

classes = doc.VNr_disp_lookup

Forall classNr In classes

Set collection = db.FTSearch(classNr, 0)

If I use it like this it works but now I need to have another criteria to be fullfilled

Set collection = db.FTSearch(classNr " AND f_studienplan", 0)

But that won’t work. I need a way to combine the value of the variable classNr with the other part of the string.

Anyone can help there?

2

Subject: FTSearch question

If you create your string in your Notes client to perform a FTSearch, the string you want will be the same (i.e. menu = View - Search This View)

Bear in mind that if you have spaces in your query parameters you should use round brackets in your query such as “(John) AND (Building Supplies)”

Does the query you are trying to build actually work in the Notes client? Try it out.

3

Subject: RE: FTSearch question

Thanks for your response but meanwhile I found another way (much simpler) to collect the documents I want.However I will keep in mind what you said maybe I will need that soon again.

Thank you :slight_smile: