Filter Active Table Schema (filter_active)


Description

Stores information about which filters are active in which contexts. Also the filter sort order. See get_active_filters in lib/filterlib.php for how this data is used.

filter_active table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
filter VARCHAR 32

The filter internal name, like 'tex'.
contextid BIGINT 19 null
context.id filtacti_con2_fk R

References context.id.
active SMALLINT 5 null

Whether this filter is active in this context. +1 = On, -1 = Off, no row with this contextid = inherit. As a special case, when contextid points to the system context, -9999 means this filter is completely disabled.
sortorder BIGINT 19 0

Only relevant if contextid points to the system context. In other cases this field should contain 0. The order in which the filters should be applied.

Table contained -1 rows

filter_active table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
filtacti_con_ix Performance Asc contextid
filtacti_confil_uix Must be unique Asc/Asc contextid + filter

filter_active table relationships

Close relationships within degrees of separation