The filter templates are stored in the "PB_FAVORITE_FILTER" table.

Table "PB_FAVORITE_FILTER"

In the header table "PB_FAVORITE_FILTER" the existing templates are specified. The table has the following structure:

Field	Type	Description
ID	uniqueidentifier	Primary Key.
FALLBACK_NAME	nvarchar(128)	The name of the filter if no translation is maintained.
JSON_CONTENT	nvarchar(max)	All settings are saved in this field and stored in JSON format.
DESCRIPTION	nvarchar(max)	The description of the filter is stored here.
IS_GLOBAL	bit	Specifies whether the filter is a global filter or a user filter.
IS_DELETED	bit	Indicates whether the filter has been deleted.

Table "PB_FAVORITE_FILTER_AFFILATION"

In the table "PB_FAVORITE_FILTER_AFFILATION" the relation of the filter is stored, for example to a user.

Field	Type	Description
ID	uniqueidentifier	Primary Key.
FAVORITE_FILTER_ID	uniqueidentifier	Reference to PB_FAVORITE_FILTER.ID.
TYPE	nvarchar(16)	Here the table name of the assignment is stored, for example "PWUSER" for the assignment to a user.
ENTITY_ID	nvarchar(12)	Here the primary key of the table referenced in "TYPE" is stored, for example the column "NAME" of the table "PWUSER".
IS_DEFAULT	bit	Here you can define whether the filter is the default for the respective relation.

In the table "PB_FAVORITE_FILTER_TRANSLATION" the translations of the filter are stored.

Field	Type	Description
ID	uniqueidentifier	Primary Key.
FAVORITE_FILTER_ID	uniqueidentifier	Reference to PB_FAVORITE_FILTER.ID.
LANGUAGE	int	Reference to IS_LANGUAGE.ID.
NAME	nvarchar(128)	The translation is entered here.

In the table "PB_FAVORITE_FILTER_TRANSLATION" is stored which filter is the default filter for a user.

Only the filters that the user himself selects as default in the planning board are stored in the table and not those for a main group or group!

Field	Type	Description
ID	uniqueidentifier	Primary Key.
FAVORITE_FILTER_ID	uniqueidentifier	Reference to PB_FAVORITE_FILTER.ID.
USER_NAME	nvarchar(12)	Reference to PWUSER.NAME.