Full text search strange behaviour

Hello all,

I hope anybody can help me with the following (Domino Server 7.02, Notes Client 7.0.2):

In a full text indexed database on the server there is a multi value field [TechnBenennung] that contains patterns like this:

Gl-01-2-8x1-1-1-0

A0-4-0-8x1-2-3-1

We-12-1-9x0-0-0-1

3/8-05-2-1-3

…etc…

When entering the following search string into the full text search bar the following behaviour occurs:

[TechnBenennung] CONTAINS “8” => 0 documents found (false)

[TechnBenennung] CONTAINS “8x” => 0 documents found (false)

[TechnBenennung] CONTAINS “8x1” => 2 documents found (correct!)

On the other hand, the following behaviour:

[TechnBenennung] CONTAINS “1” => several documents are found, but not the ones that contain “8x1” !?

It seems as if the combination of a character, followed by “x”, followed by another character is completely ignored by the search.

The full text index has been refreshed several times and even created completely new.

Does anyone have an explanation for this, or who can help me?

Thank you in advance

Joachim

Subject: Full text search strange behaviour

You say you have recreated the FTI. Did you delete the folder from the server? I have found that you need to delete the folder & its contents before a recreate really does create a new index.

ARe you searching from an agent or using the FT Search? If the search then it will only operate on the view that you are in when you start the search - an agent searches the whole database, however it can get a bit stressed and you might need to break a search down into small bits.

Subject: RE: Full text search strange behaviour

Hello Sue,

thank you for your response.

I will create a new FTI with a prior deleting all folders and test again.

The search is started from a view - but the expected documents definitively are in that view.

I will post again after a new FTI has been created.

Best regards

Joachim

Subject: Full text search strange behaviour

When you search for “8x1” it returns documents because there are documents containing the “word” 8x1 – hyphens are seen as word breaks in the index. You need to use a wildcard (? or ) in order to use a particle of a word for a search. [TechnBenennung] CONTAINS “8??” and [TechnBenennung] CONTAINS "8" would both return two documents in your example.

Subject: RE: Full text search strange behaviour

Hello Stan,

thank you very much. I tested analog to your explanation, and you are absolutely right.

I was not aware of the meaning of hyphens - so now I am a little more clever :slight_smile:

Thank you again.

Joachim

Subject: Full text search strange behaviour

After deletion of the FTI (inclusive all folders) and regenerating the FTI the same behaviour - no success.

Joachim