Grant Lindsay commented on Oct 5, 2015

Re: Full-text Syntax

Does anyone know if there is a limit to the length of the query itself?

Some experimentation I did suggests approximately 27,800 characters is the most a query can contain. (27,754 characters was fine, 27,801 was too many/much.) There may be internal query overhead that makes up the rest (32K - 5,000 = 27,768, which falls within my range) or there may be another, less obvious limit, like number of terms or complexity (however that might be measured.)

In any case, once the limit--whatever it is--is exceeded, the call to NotesDatabse.FTSearch() returns: "Exception occurred calling method NotesDatabase.FTSearch(string, number)\nnull" (SSJS)

I was just curious if anyone else had seen this or could shed some light on the apparent limit.

Raimund Guertl commented on Jan 19, 2015

Re: Full-text Syntax

use IS PRESENT for empty fields (e.G. [AuthorField] IS PRESENT Finds documents whose AuthorField field is non-blank. (from Help))

Eric Radloff commented on Nov 17, 2014

Re: Full-text Syntax

If I want to query for documents with a field that has an empty value (I.E., [AuthorField] = "" ) how do I do that in an "understandable" query? The syntax I just cited is "not understandable" unless I put something inside the quotes, which is what I want to avoid doing.

Leonardo Prizont commented on Mar 23, 2011

Re: Full-text Syntax

This is a much needed page - however, it does not display correctly in Firefox - everything to the left of the "Web Search" column is cut off.

Gerald Mengisen commented on May 6, 2009

Addition for dates

Enclose hard coded dates with the hash sign (#), like #12/31/2008#