The filter templates are saved in the tables "fsplanningboardfilter" or "fsplanningboardfilteritems".

Table"fsplanningboardfilter"

The existing templates are specified in the header table "fsplanningboardfilter". The table has the following structure:

Field	Type	Description
ISGUID	uniqueidentifier	Primary Key.
USERNAME	varchar(12)	The name of the user for whom the template is defined (reference to PWUSER.NAME).
NAME	varchar(255)	The name of the template. Displayed in the selection list in the planning board.
ISDEFAULT	bit	1, if the template should be automatically taken into account when opening the planning board. Maximum one "default" template per user.

Table"fsplanningboardfilteritems"

The individual values of the filters are saved in the table "fsplanningboardfilteritems".

Field	Type	Description
ISGUID	uniqueidentifier	Primary Key.
FILTERGUID	uniqueidentifier	Reference to FSPLANNINGBOARDFILTER.ISGUID.
TYPE	varchar(50)	The type of filter for which the value is saved.
POS	int	The index of the value in the filter. Unique per FILTERGUID-TYPE combination.
STRINGVALUE	varchar(255)	String values are stored in this column.
INTVALUE	int	Integer values are stored in this column.
BOOLVALUE	bit	Boolean values are stored in this column.
DATEVALUE	datetimes	Date values are stored in this column.

Underline = The field is required

The following filters are currently stored:

Type	Description
address	Address filter
resource	Resource filter
project	Project filter
group	Group selection
maingroup	Main group selection
externalresources	Switch for showing or hiding the external resources
resourceswithassignments	Switch to display only the resources that have at least one assignment.
containerswithassignments	Switch for displaying only the work list that have been assigned at least one assignment.
assignmentcode	Code filter
resourcelocation	Standortauswahl