Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Comparison Rules allow users to construct business rules by comparing one Workflow Attribute against another attribute or a static value. They are widely used through the system to govern things such as:

  • Workflow access controls
  • Field visibility rules
  • Data entry validation rules
  • etc

Different comparison operators are supported for different data types:

(tick) = Supported / (error) = Not supported 

(star) = Data type is optimized for bulk operations 



Empty/

Not Empty

Equals/

Not Equal

True/

False

<, <=,

>, >=

Between

Contains

Substring

Contains

Item

Activity Container
(error)(error)(error)(error)(error)(error)(error)
Activity Lookup
(tick)(error)(error)(error)(error)(error)(error)
Assessment Definition
(tick)(error)(error)(error)(error)(error)(error)
Assessment Instance
(error)(tick)(error)(error)(error)(error)(error)
Autonumber(star)(tick)(tick)(error)(error)(error)(error)(error)
Boolean(star)(tick)(tick)(tick)(error)(error)(error)(error)
Competency Classification
(tick)(error)(error)(error)(error)(error)(error)
Date (star)(tick)(tick)(error)(tick)(tick)(error)(error)
Date Stamp(star)(tick)(tick)(error)(tick)(tick)(error)(error)
Date Time(star)(tick)(tick)(error)(tick)(tick)(error)(error)
Discussion
(tick)(error)(error)(error)(error)(error)(error)
Email(star)(tick)(error)(error)(error)(error)(error)(error)
Entity Image
(tick)(error)(error)(error)(error)(error)(error)
Entity List
(tick)(error)(error)(error)(error)(error)(error)
Image
(tick)(error)(error)(error)(error)(error)(error)
Long Text (star)(tick)(tick)(error)(error)(error)(tick)(error)
Member
(tick)(tick)(error)(error)(error)(error)(error)
Multi-select(star)(tick)(error)(error)(error)(error)(error)(tick)
Numeric (star)(tick)(tick)(tick)(tick)(tick)(error)(error)
Payment
(tick)(error)(error)(error)(error)(error)(error)
PD In Focus
(tick)(error)(error)(error)(error)(error)(error)
Picklist(star)(tick)(tick)(tick)(error)(error)(error)(error)
QR Code
(tick)(error)(error)(error)(error)(error)(error)
Rating
(tick)(error)(error)(error)(error)(error)(error)
Rich Text
(tick)(error)(error)(error)(error)(error)(error)
Short Text (star)(tick)(tick)(tick)(error)(error)(tick)(error)
Supervisor(star)
Upload
(tick)(tick)(error)(error)(error)(error)(error)
(error)
Tag List
Vimeo
(star)(tick)(error)(error)(error)(error)(error)
(error)
(tick)
Upload
xx

(tick)(error)(error)(error)(error)(error)(error)
(error)
Vimeo
xx

(tick)(error)(error)(error)(error)(error)(error)
(error)
Template
xx

(tick)
(error)
(tick)
(error)
(tick)(error)(error)
(error)
(tick)(error)
(error)xx
Tenant Multi-Select
(tick)(error)(error)(error)(error)(error)(error)
(error)

...











TODO: Document "extended properties"

TODO: Why does Container support Equal/Not Equal but not Empty/Not Empty?

TODO: Document performance optimizations