report_builder_filters table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| reportid | BIGINT | 19 | null |
|
|
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
Close relationships within degrees of separation
