Skip to content

MPE_FILTERANYTABLE

The MPE_FILTERANYTABLE table stores a record for each unique filter created via the FILTER menu. When a user submits a filter, the entire clause is hashed - if that hash already exists for the table, the existing FILTER_RK is reused, otherwise a new record is added. This means identical filters are only ever stored once, and the FILTER_RK can be safely embedded in the shareable URLs described in the filter guide.

The individual lines of the filter clause itself are stored in MPE_FILTERSOURCE.

Columns

  • 🔑 FILTER_RK num: Unique retained key for the filter, used to recall the filter (eg in shareable URLs)
  • FILTER_HASH char(32): Hash of the entire filter clause, used to detect duplicate filters and to join to MPE_FILTERSOURCE
  • FILTER_TABLE char(41): The table being filtered (in libref.dataset format)
  • PROCESSED_DTTM num: Datetime the filter was first created