Table Name:	web_filter
Table Number:	5367
Group:	Resource_mgr
Description:	Object which stores the in-memory definition of a filter. Used for displaying orders and cases in the Customer Portal
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_web_filter

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
is_default	LONG	tinyint			0	DIRECT	If the filter is the web user's default filter, 0=no, 1=yes, default=0	Search (1)
obj_type	LONG	int				DIRECT	Object type ID of the base schema object the web_filter is for; e.g., 0=case, 52=site	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
title	CHAR	varchar		80			Name of the web_filter	Search (1)
update_stamp	CLK_TIME	datetime	46			ALLOW_NULL	Date/time of last update to the web_filter
view_type	LONG	int				DIRECT	Type ID of the schema view being used for web_filter; differs based on object type	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
web_filter2query_elm	OTM	query_elm	query_elm2web_filter	Property list items for the web_filter
web_filter2sort_elm	OTM	sort_elm	sort_elm2web_filter	Sort criteria for the web_filter
web_filter2web_user	MTO	web_user	web_user2web_filter	Web_user that originated/created web_filter			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
web_filter_ind	web_filter2web_user:obj_type:title	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
web_filter_ind	web_filter2web_user, obj_type, title	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5368	v_web_filter	web_filter, web_user

My Recent Objects

web_filter

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user