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…

Published by

lekkim

Positive, competent, out-spoken, frank and customer focused architect and developer with a strong foundation in web, cloud and product development. I'm a strong advocate for API first and cloud based solutions and development. I have a knack for being able to communicate and present technically complicated matters in conference, customer and training settings. I've previously acted as team member and leader in a product organisation.

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

  3. 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.