FTSearch returns extra values

HCL Domino Domino Forum
1

I have a query like this that I pass to db.FTSearch:

FIELD FORM = FORMA AND FIELD FIELDA = 2005

What happens is that the results no only get me the documents with FIELDA = 2005, but also any occurrence of “2005”, e.g. “YEAR 2005”, etc.

Is there a way to specify that I want FIELDA exactly to match what I specify and nothing else? Also, I don’t know what values to exclude, so I just want to be able to specify what I’m looking for and that’s it.

Thanks for any help!

2

Subject: FTSearch returns extra values

Hi Liza,

are you doing this in LS - or in the search bar as a user?

Would you mind to place some code snipplet here?

Uwe