Dropping the FIELD-keyword from the fulltext search syntax…

As posted the other day (To OR or not to OR…) you can use parenthesis’ to condense the fulltext search string in Notes when OR’ing terms together. Another option I just discovered today is to use square brackets instead of the “FIELD”-keyword.

The search query

FIELD xxx CONTAINS yyy

can therefore also be written as

[xxx] CONTAINS yyy

Combining this with my previous post a verbose search query such as

(FIELD xxx CONTAINS yyy) OR (FIELD xxx CONTAINS zzz) OR (FIELD xxx CONTAINS www)

can therefore be written much shorter as

[xxx] CONTAINS (yyy, zzz, www)

It makes you wonder which other gems are hidden in the fulltext search syntax doesn’t it…

3 thoughts on “Dropping the FIELD-keyword from the fulltext search syntax…”

  1. Great !
    How could I find this string in a database ? How should be written the request ? and in LScript ?

    thetring=1

    Thanks for your help,
    Frédéroc

Comments are closed.