Report Builder Filters Table Schema (report_builder_filters)


Defines filters belonging to each report

report_builder_filters table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
reportid BIGINT 19 null repobuilfilt_rep2_fk R

ID of the report this column belongs to

type VARCHAR 255

Type of filter, used with value to identify the filter option

value VARCHAR 255

Value of filter, used with type to identify the filter option

sortorder BIGINT 19 null

Determines the order that the filters appear in the report

advanced SMALLINT 5 0

If none zero then the filter is an advanced option

filtername VARCHAR 1024 null

Visible name describing the filter to report users

customname SMALLINT 5 0

Indicates whether the user has customised a name or if they are still using the default filter name value

region SMALLINT 5 0

Indicates whether filter appears at the top or in the sidebar

defaultvalue LONGTEXT 2147483647 null

Serialized data containing the default value for the filter

Table contained -1 rows

report_builder_filters table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repobuilfilt_rep_ix Performance Asc reportid

report_builder_filters table relationships