Performitor

Sr.No	Name	Type	Comments
1	id	Primary int
2	filtertypeid	Index int
3	displayparams	text	Stores the query in such a format so as to return id and name for the filter. This is used when the filter options are dynamic or not straightforward
4	value	varchar(200)	the value that is to be matched when this option is chosen
5	valueparams	text	value in terms of query, that is to be matched when this option is chosen
6	reportparam	text	this column holds the query which helps in splitting the chosen filter data into individual options
7	filteroptionsord	int	the order in which filter options are to be appeared within a category('filtertypeid')
8	clickability	int	0=unclickable, 1=clickable
9	parentfilteroptionid	int	id of fw_filteroptions itself, to which this option is a sub branch
10	carryforwarddisplaytext	int	if set, this displaytext is forwarded to the 'rel' option text of its successor option
11	firstviewfilteroptionid	int	used to store the filteroptionid which is used for first view dashboard (Ex: filteroptionid of Laatste 4 metingen)
12	status	int	0=inactive, 1=active