Auto No. (Prefixed)

Long Text

String

File

• EQUAL TO
• NOT EQUAL TO
• IS NULL
• IS NOT NULL
• CONTAINS
• NOT CONTAINS

• Value
• Constant *
• Component Constant ** Attribute
• Field or Relationship
• Profile Value
• Parameter

* all constants that are not Component constants, ie those whose 'Type' is other than 'attrib'.

** Constants whose 'Type' is 'attrib'. Most common is the User-Person link.

See User-defined Constants

• BEGINS WITH
• NOT BEGINS WITH
• ENDS WITH
• NOT ENDS WITH
• IN
• NOT IN

• Value

• IS NULL
• IS NOT NULL

Currency

Decimal

• EQUAL TO
• NOT EQUAL TO
• GREATER THAN
• GREATER THAN OR EQUAL TO
• LESS THAN
• LESS THAN OR EQUAL TO
• BETWEEN
• IS NULL
• IS NOT NULL

• Value
• Constant
• Component Constant Attribute
• Field or Relationship
• Profile Value
• Parameter

Date

Auto No. (No Prefix)

Integer

Time

• EQUAL TO
• NOT EQUAL TO
• GREATER THAN
• GREATER THAN OR EQUAL TO
• LESS THAN
• LESS THAN OR EQUAL TO
• BETWEEN

• Value
• Constant
• Component Constant Attribute
• Field or Relationship
• Profile Value
• Parameter

• IS NULL
• IS NOT NULL

Single Lookup

Multi-Lookup

• EQUAL TO
• NOT EQUAL TO

• Value
• Constant
• Component Constant Attribute
• Field or Relationship
• Profile Value
• Parameter

• IN
• NOT IN

• Value

Matrix (Results Only)

Question

• EQUAL TO
• NOT EQUAL TO

• Value
• Constant
• Component Constant Attribute
• Field or Relationship
• Profile Value
• Parameter

One to One Relationship

Many to One Relationship

• EQUAL TO
• NOT EQUAL TO

• Value
• Constant
• Component Constant Attribute
• Field or Relationship
• Profile Value
• Parameter

• IN
• NOT IN

• Value

• HAS
• HAS NO

One to Many Relationship

Many to Many Relationship

** Relationships directly below the root Component e.g Incident/Injuries.

• HAS
• HAS NO
• EQUAL TO
• NOT EQUAL TO

One to Many Relationship

Many to Many Relationship

** Relationships two or more levels from the root Component e.g. Incident/Injuries/Days Lost

• HAS
• EQUAL TO
• NOT EQUAL TO