Comparison Rules

Owned by Seth Petry-Johnson
Last updated: Jun 07, 2019
1 min read

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

Greater / Less ThanBetween

Contains

Substring

Contains Item

Extended Properties /

Special behaviors

Activity Container
(error)(error)(error)(error)(error)(error)(error)
  • Total activity count
  • Total completed successfully
  • Total completed unsuccessfully
  • Total incomplete
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)
  • Assessment Status
  • Pass / Fail
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)
  • Comparison to date offset (star)
Date Stamp(star)(tick)(tick)(error)(tick)(tick)(error)(error)
  • Comparison to date offset (star)
Date Time(star)(tick)(tick)(error)(tick)(tick)(error)(error)
  • Comparison to date offset (star)
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)(tick)(tick)(error)(error)(error)(error)(error)
Tag List(star)(tick)(error)(error)(error)(error)(error)(tick)
Upload
(tick)(error)(error)(error)(error)(error)(error)
Vimeo
(tick)(error)(error)(error)(error)(error)(error)
Template
(tick)(tick)(tick)(error)(error)(tick)(error)
Tenant Multi-Select
(tick)(error)(error)(error)(error)(error)(error)










Bulk Operation Support (star)

As of LearningBuilder 9.1, certain Comparison Rules can be evaluated directly in the database to dramatically improve performance of bulk operations. 

In order for this optimization to occur, the Comparison Rule must:

  1. Target an Extrinsic attribute of a supported data type (see table above) or a supported Intrinsic attribute  
  2. Be used in a feature that supports bulk optimization

As of 9.1, the features supporting bulk optimization are:

  1. Scheduled Workflow Behaviors

Extended Properties

Certain data types expose more than one value that can be targeted by a Comparison Rule. This is commonly seen in data types representing complex interactions or in "container" type attributes.

(warning) NOTE: Unless specially noted, rules targeting extended properties are NOT optimized for bulk operations, regardless of the data type.

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