LotusScript Logical Operators

There are times that you will need to check a particular FORM for a certain Value in a specific FIELD. By using logical operators and the dbCollection.search or dbCollection.FTSearch, you can narrow things down considerably in your collection.

Below is a reference table for Notes Operators and their Precedence Levels. Couple that with Formula Keywords and you could get a search query statement like this:

{ Form="Notice" & @Contians(Location,"800-CallMe") & IsMailStationery != 1}

Now, you can find notices in your mail file for meeting invitations. But only for users who responded to the call number 800-CallMe (if you placed the number into the Location field of the invitaion :-)

This makes organizing your mailbox even easier, while you can keep track of meetings associated with the information / contents of the folders we used in the Inbox Cleaner.

**Notes Operators and their Precedence Levels**
Operator	Operation	Precedence
:=	Assignment
:	List concatenation	1
+, -	Positive, Negative	2
* ** / */	Multiplication Permuted Multiplication Division Permuted Division	3
+ + - -	Addition, Concatenation Permuted Addition Subtraction Permuted Subtraction	4
= = <> != =! >< <> < < > > <= <= >= >=	Equal Permuted equal Not equal Not equal Not equal Not equal Permuted not equal Less than Permuted less than Greater than Permuted greater than Less than or equal Permuted less than or equal Greater than or equal Permuted greater than or equal	5
! & \|	Logical NOT Logical AND Logical OR	6

Formula Keywords

There are five keywords that are used with formulas:

	DEFAULT
	ENVIRONMENT
	FIELD
	REM
	SELECT