Skip Navigation

Advanced search attribute types

The following table lists the different attribute types, operators, and values you can use in an advanced search. It also provides examples to illustrate how each attribute criteria would appear in the advanced search field.
Attribute Type
Operator
Value
Examples
Checkbox
is
Yes
  • Currently Online is Yes
  • CPR Certified is No
Date
equals, not equals, before, after
Date Panel (showing date value + Past & Next x days value)
  • Joining Date equals 5/4/201
  • CPR Expiration Date older than Sysdate - 30 days
Date
is empty, is not empty
Hide
  • Expiration Date is empty
Date Time
before, after
Date Time Panel (showing date value + Past & Next x days value)
  • Age is empty
  • Age is not empty
Date Time
is empty, is not empty
Hide
--
Geolocation
is inside, is outside
Map screen to show selections
  • Home Location is inside shape on the map
Geolocation
is empty, is not empty
Hide
  • Office Location is empty
Memo
Multi-select Picklist
equals, not equals, is empty, is not empty
Multi-value selection options
  • Emergency Community not equals Fire
  • Rank equals Commander, Captain
Number
equals, not equals, greater than, less than
Whole number without decimals
  • Age equals 30
  • Age greater than 18
  • Age less than 65
Number
is empty, is not empty
Hide
  • Age is empty
  • Age is not empty
Single-select Picklist
equals, not equals, is empty, is not empty
Single-value selection option
  • Building is not empty
Status
equals, not equals, is empty, is not empty
Text(String)
equals, not equals, starts with, ends with, contains, does not contain
Alphanumeric text
  • First Name equals John
  • First Name starts with A
  • First Name contains andy
Text(String)
is empty, is not empty
Hide
  • First name is empty
Org Hierarchy
at, at or below, not at, not at or below
Multiselection of node in hierarchy
<Node name or names>