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…
Great tip. Thanks, Jack
[xxx] = (yyy, zzz, www) is even shorter. 🙂
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