criteria Field

[This is preliminary documentation and subject to change.]

A SQL WHERE condition restricting which items trigger a bound event sink's notification of an OnSave, OnDelete, OnSyncSave, and OnSyncDelete event.

Full Name

http://schemas.microsoft.com/exchange/events/criteria

Name Constant

None

Variant (Automation) Subtype

[Visual Basic] String

[C++] VT_BSTR

OLE DB Type

DBTYPE_WSTR

Remarks

The Web Store event source determines whether to notify a bound event sink of an OnSave, OnDelete, OnSyncSave, or OnSyncDelete event by checking whether the triggering item satisfies the any SQL WHERE condition present in the event sink binding item's criteria property. The following conditions are supported for this purpose:

AND, OR, NOT, EXISTS

Use double quotes for property names and single quotes for strings to be evaluated. Custom properties must be explicitly cast to the proper type. For example:

"WHERE cast($MyNumber$ as 'i4')<>15"

Use of the CONTAINS condition in this binding property is not supported. This property is not used for system events.

Example

WHERE "SomeProp" = '.txt'

WHERE "SomeUserProp" IS NOT NULL

WHERE "IsHidden" = FALSE