Table Name:	ce_query
Table Number:	4312
Group:	fcQuery
Description:	Data record for one query
Flags:
Baseline/Custom:	Custom

Fields
Relations
Indexes
Referenced in Views

select * from table_ce_query

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
alias	CHAR	varchar		64		USER_DEFINED	Alias of object to do query on
asc_desc	LONG	int				USER_DEFINED	Is the query ordered ascending (0) or descending (1)?
asc_desc2	LONG	int				USER_DEFINED	Is the second sort field ordered ascending (0) or descending (1)?
complex	LONG	int				USER_DEFINED	Was the query built with standard options (0) or complex (1)?
dev	LONG	int	151			USER_DEFINED, ALLOW_NULL	Row version number for mobile distribution purposes
is_distinct	LONG	int				USER_DEFINED	Does the query use the distinct clause (=1), or not (=0)?
objid	LONG	int	3			USER_DEFINED	Internal record number
query_name	CHAR	varchar		255		USER_DEFINED	Name of the query
query_type	CHAR	varchar		30		USER_DEFINED	Type of the query
shared	LONG	int				USER_DEFINED	Is the query shared (=1), or personal (=0)
shared_to_all	LONG	int				USER_DEFINED	Is the query shared to all users (=1), or not (=0)
sort1	CHAR	varchar		255		USER_DEFINED	Sort field 1 for the query
sort2	CHAR	varchar		255		USER_DEFINED	Sort field 1 for the query
sql_stmt	CHAR	text				USER_DEFINED, ALLOW_NULL	SQL Statement for the query

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
ce_query2ce_clause	OTM	ce_clause	ce_clause2ce_query	Query clauses for this query	USER_DEFINED
ce_query2ce_iconified	OTM	ce_iconified	ce_iconified2ce_query	The query is iconified	USER_DEFINED
ce_query2ce_object	MTO	ce_object	ce_object2ce_query	Object for this query	USER_DEFINED
ce_query2ce_query_col	OTM	ce_query_col	ce_query_col2ce_query		USER_DEFINED
ce_query2user	MTO	user	user2ce_query	Which user owns this personal query	USER_DEFINED
ce_query2shared_to	MTM	user	shared_queries2ce_query	Users who accept this shared query	USER_DEFINED	mtm_user115_ ce_query2
ce_query2refused_by	MTM	user	refused_queries2ce_query	Users who reject this shared query	USER_DEFINED	mtm_user116_ ce_query3

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

ce_query

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user