To OR or not to OR…

Many of you might know this already but when fulltext searching a Domino database and you need to OR some arguments together you have two choices for the syntax.

The verbose option (which I have been using so far):

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

or the much less verbose option that achieves the same as the above example (which I learned today from a co-worker):

FIELD xxx CONTAINS (yyy, zzz, www)

He found the syntax using trial-and-error – go figure!! 🙂

P.S.: It would be really interesting if there is a AND shorthand as well…

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.