Skip to content

MPE_FILTERSOURCE

The MPE_FILTERSOURCE table stores the individual query lines of each filter created via the FILTER menu, keyed by the hash stored in MPE_FILTERANYTABLE. See the filter guide for more details.

Columns

  • 🔑 FILTER_HASH char(32): Hash of the filter clause, joining to MPE_FILTERANYTABLE
  • 🔑 FILTER_LINE num: Line number within the filter clause
  • GROUP_LOGIC char(3): AND / OR logic applied between groups
  • SUBGROUP_LOGIC char(3): AND / OR logic applied within the subgroup
  • SUBGROUP_ID num: Identifier of the subgroup to which this line belongs
  • VARIABLE_NM char(32): The variable being filtered
  • OPERATOR_NM char(12): The filter operator (e.g. =, >, IN)
  • RAW_VALUE char(4000): The filter value
  • PROCESSED_DTTM num: Datetime the filter line was created