While using the fulltext search in a Lotus Notes DB. I am searching for a field to contain a value. If I physically look for this value I find documents, however I do not if I use the fulltext search.
If I use the following in the fulltext search:
field InternalID_n is equal to 400343
I get no results at all, yet I can physically scroll down the view and see documents that I am looking for.
Now if I use:
field ConsumerID is equal to 400343
I get results, 115 fields (yes both fields each have the same value)
I did a property comparison and the fields are exactly the same except for the name of the fields
I have ripped out the fulltext index and rebuilt it 3 times just to rule it out as being the problem
the requirements state that I have to use InternalID_n
No I did not develop this app but have been charged with adding to it.
can anyone give me a clue why InternalID_n fails, yet ConsumerID works
Is it possible that somewhere in the life of Lotus Notes, InternalID_n is a reserved word in one way or another?