Full-Text Search: works and does not work across copies and replicas

HCL Domino Domino Forum
1

Full Text Query: (Field Year = 2011)Field Name: Year

Field Type: Number

Copies and Replicas of databases:

Domino Server | Query Returns Documents

6.5.5 Yes

7.0.1 No

8.0.2 Yes

8.5.2 No

My production server for this app is running 7.0.1. however I think I may have a field type problem.

On Servers that work I can use the Query Builder Field option. When I pick the field Year from the list, the dropdown lets me pick “is equal to”.

When I use the Query Builder on the servers that don’t work, the dropdown lets me pick “is on”.

Could this be a data type problem for the field? Any suggestions to get this full-text query to work will be greatly appreciated.

  • Gary
2

Subject: Full-text Solution

I tried the following with no success:1. delete the index.

  1. run agent that deletes field and then adds it again with the value as a number.

  2. Create full-text index.

This worked:

  1. delete the index

  2. run agent that copies the value from Year field to RegYear field.

  3. Create full-text index.

  4. Change code to use RegYear instead of Year field.