Optional Masks

Optional masks can be used in addition to a method. The mask is added to the specified method as an and operation and the mask result is used in the operation. If an optional mask is not specified, the field_value element is used as-is.

MATRIXX supports optional masks for the following methods:
  • equal
  • greater
  • greater_or_equal
  • less
  • less_or_equal
  • not_equal
To allow more complex logic in the selection phase, a field_mask_in_hex can be specified. The value must be specified in hex and can be used on the following data types:
  • BLOB
  • INT8
  • INT16
  • INT32
  • INT64
  • INT128
  • OBJECT_ID
  • PHONE_NUMBER

    In a mask for a PHONE_NUMBER type field, each hex character of the mask relates to a digit in the PHONE_NUMBER field. To use an odd-length mask, you must append a "0" to the end of the mask so that it is an even number of hex characters. For example, a mask of "FFF0" indicates that the mask applies to the first 3 digits of the PHONE_NUMBER field.

  • STRING
  • UINT8
  • UINT16
  • UINT32
  • UINT64
  • UINT128