Ftsearch problems

HCL Domino Domino Forum
1

FTSearch is a real problem for me at the moment.

If I create a search query:

FIELD Team contains Energy and PubDate is between 01/05/2009, 13/05/2009

it gives results where field team does not contains energy, and misses out some that contain energy

So, I go to a view with all the relevant documents in to try this out manually and type in the search query, getting exactly the same weird results.

BUT - if I create the Pubdate query using the More… section by field it works just fine.

I can then remove the Notes created search string and retype EXACTLY the same text and it gives strange results again

How can this happen???

Any ideas, I have reporting based on this search and it’s basically broken.

I’ve deleted the index and recreated it for this db with no joy

Thanks for any suggestions

Dan

2

Subject: full text search syntax

The full text search has a syntax which is documented in the CLIENT help (i.e. not Designer help), in a document entitled, “Refining a search query using operators”. In your case, you probably want to do something like:

[PubDate] >= 01/05/2009 and [PubDate] < 13/05/2009

The gray-box search terms display user-friendly text, not the picky syntax of the FTSearch engine.

3

Subject: Thanks

That does ring a bell actually Andre. Did try a forum search but couldn’t find anything and been a while since I last had the issue. Will try and remember this time:)

Find it a bit odd that the syntax should be different though, but it’s working now

Cheers

Dan