filter_active

0 rows


Description

Stores information about which filters are active in which c

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_fkR

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.

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

Relationships