<< Displaytag 1.1 released | Home | I dare you to further shorten it further... (search syntax part 3) >>

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



Avatar: Jack Dausman

Re: Dropping the FIELD-keyword from the fulltext search syntax...

Great tip. Thanks, Jack
Avatar: Jens Polster

Re: Dropping the FIELD-keyword from the fulltext search syntax...

[xxx] = (yyy, zzz, www) is even shorter. :-)
Avatar: Fred

Re: Dropping the FIELD-keyword from the fulltext search syntax...

Great ! How could I find this string in a database ? How should be written the request ? and in LScript ? thetring=<OB10Marker Type="Failed">1</OB10Marker> Thanks for your help, Frédéroc