Ft-search gives more than it should be

HCL Domino Domino Forum
1

we build a webtool to search for documents.

we build a search like (FIELD field1 = test) and (FIELD project = prj1)

the query returns also documents where the field projects contacts values equals to prj1-test

why ?

thanks for your help

2

Subject: ft-search gives more than it should be

oops,error in my previous post.

text is :

where the field projects CONTAINS also values equals to prj1-test.

He ignores values like prj11

I think the “-” will interpreted as a value separator ??

3

Subject: ft-search gives more than it should be

I’m only guessing, but build it like this( (FIELD field1 = test) and (FIELD project = prj1) )

4

Subject: ft-search gives more than it should be

If you’re using FTSearch in LotusScript, read the Help file. FTSearch returns any document that has any of the words you put into it in any field. Try using NotesDatabase.Search instead. It allows you to specify field values as criteria.

5

Subject: ft-search gives more than it should be

The search syntax looks correct to me. How exactly do you do this web based search?

Your result acts as if the argument SearchFuzzy or/and SearchWV would have been used. Or could there be some other code somewhere that puts in additional wildcard characters?

6

Subject: ft-search gives more than it should be

The “=” is not “EQUALS”, it’s “CONTAINS” – and FTSearch will see the hyphen as a word boundary. Since “prj1-test” contains the word “test”, it will be returned.

7

Subject: RE: ft-search gives more than it should be

hi stan,

my query is : (FIELD field1 = test) and (FIELD project = prj1)

it will returned because the field project contains “prj1-test” and prj1 is contained in prj1-test.

Very strange that ‘=’ is NOT “equal” but “contains”

8

Subject: RE: ft-search gives more than it should be

The “=” is just an alias for the keyword “CONTAINS”. If you get into the habit of using the keywords instead of the “operator” aliases, you’ll have a better idea of what your query is actually looking for.

9

Subject: RE: ft-search gives more than it should be

And this is all well documented. Unfortunately not in Designer help, but in the client help, only.