Asset 360 Suite > Appendix > Field Data Type Matrix
Field Data Type Matrix
The following table displays the field data type matrix for different expressions. Yes indicates an operator is available for the corresponding data type and No indicates an operator is unavailable for the corresponding data type.
Operators ->
Equals
Not Equals
Greater Than
Greater or Equal To
Less Than
Less or Equal To
Starts With
Contains
Does Not Contain
Is Null
Is Not Null
Includes
Excludes
Data Types
Auto Number
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
Name
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
Lookup Relationship
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
Formula (Text)
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
Picklist
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
URL
Yes
Yes
No
No
No
No
Yes
Yes
Yes
Yes
Yes
No
No
Text
Yes
Yes
No
No
No
No
Yes
Yes
Yes
Yes
Yes
No
No
Text Area
Yes
Yes
No
No
No
No
Yes
Yes
Yes
Yes
Yes
No
No
Text Area (Long)
Yes
Yes
No
No
No
No
Yes
Yes
Yes
Yes
Yes
No
No
Text Area (Rich)
Yes
Yes
No
No
No
No
Yes
Yes
Yes
Yes
Yes
No
No
Text (Encrypted)
Yes
Yes
No
No
No
No
Yes
Yes
Yes
Yes
Yes
No
No
Email
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
Number
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Formula (Number)
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Roll-Up Summary
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Currency
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Date
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Date/Time
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Phone
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Time
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Percent
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Long Text Area
No
No
No
No
No
No
No
No
No
Yes
Yes
No
No
Textbox
Yes
Yes
No
No
No
No
No
No
No
No
No
No
No
Picklist (Multi-Select)
Yes
Yes
No
No
No
No
No
No
No
Yes
Yes
Yes
Yes
Was this helpful?