Table Name:	axfprops
Table Number:	5466
Group:	Info Retrieval
Description:	Filter properties for a particulat XFilter object
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_axfprops

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
addnl_info	CHAR	varchar		255		ALLOW_NULL	Additional information about filter properties
control_type	LONG	int				DIRECT, ALLOW_NULL	This is implementation specifics, it indicates the type of set of controls available in the advance search window: e.g., date control, string control, number control mapped to an integer
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
display_name	CHAR	varchar		255		ALLOW_NULL	The name of the property/field that will be displayed in the UI.
friendly_name	CHAR	varchar		30			Friendly Name of the filter field
is_displayable	LONG	tinyint			0	DIRECT, ALLOW_NULL	Is property displayed in the Advance Search; 0=no,1=yes;default=0
objid	LONG	int	3			DIRECT	Internal record number
path	CHAR	varchar		255			Actual path of the field

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
axfprops2gbst_lst	OTOP	gbst_lst	gbst_lst2axfprops	A relation to a GBST list if there is one for the property/field
axfprops2xfilter	MTO	xfilter	xfilter2axfprops	Related xfilter

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
I5466	friendly_name:axfprops2xfilter	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
a2x5466	axfprops2xfilter	nonclustered located on PRIMARY
I5466	friendly_name, axfprops2xfilter	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

axfprops

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user