Table Name:	query
Table Number:	203
Group:	Info Retrieval
Description:	EIS object which stores the definition of a query as defined by a user
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_query

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
default_val	LONG	int				DIRECT	Indicates whether the query invokes properties, keyphrases, or both	Search (2)
description	CHAR	varchar		255			Description of the query. Used only by Billing Manager
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
keyword_mode	CHAR	varchar		10			If using keywords, match All or Any	Search (2)
obj_type	LONG	int				DIRECT	Object type ID the query is for; e.g., case=0, solution=1, subcase=24, change request=192	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (2)
order_val	LONG	int				DIRECT	Ascending or descending sort criteria	Search (2)
prompt_ind	LONG	tinyint				DIRECT	Indicates whether the query uses a run-time prompt; i.e., 0=no prompt, 1=prompt, default=0	Search (2)
prompt_ind_st	CHAR	varchar		20			Translates prompt_ind	Search (2)
shared_pers	LONG	tinyint				DIRECT	Indicates whether the query is shareable with users other than the originator; i.e., 0=private, 1=shareable, default=0	Search (2)
shared_pers_st	CHAR	varchar		20			Translates shared_pers	Search (2)
sql_statement	CHAR	text				ALLOW_NULL	SQL code created based on parameters entered by user for the query	Search (2)
stored_prc_name	CHAR	varchar		40			Reserved for the name of the stored procedure for the query	Search (2)
title	CHAR	varchar		80			Name of the query	Search (2)
view_type	LONG	int				DIRECT	Schema view being used for query; differs based on object type	Search (2)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
query2keywd_elm	OTM	keywd_elm	keywd_elm2query	Keywords used for the query
query2qry_grp	MTM	qry_grp	qry_grp2query	Relation to one or more query groups; allows iconification		mtm_query16_ qry_grp1
query2query_elm	OTM	query_elm	query_elm2query	Property list items for the query
query2sort_elm	OTM	sort_elm	sort_elm2query	Sort criteria for the query
first_query2trnd	OTM	trnd	trnd_1query2query	First query used in a trend
second_query2trnd	OTM	trnd	trnd_2query2query	Second query used in a trend
third_query2trnd	OTM	trnd	trnd_3query2query	Third query used in a trend
fourth_query2trnd	OTM	trnd	trnd_4query2query	Fourth query used in a trend
fifth_query2trnd	OTM	trnd	trnd_5query2query	Fifth query used in a trend
sixth_query2trnd	OTM	trnd	trnd_6query2query	Sixth query used in a trend
seventh_query2trnd	OTM	trnd	trnd_7query2query	Seventh query used in a trend
eigth_query2trnd	OTM	trnd	trnd_8query2query	Eighth query used in a trend
ninth_query2trnd	OTM	trnd	trnd_9query2query	Ninth query used in a trend
tenth_query2trnd	OTM	trnd	trnd_10query2query	Tenth query used in a trend
eleventh_query2trnd	OTM	trnd	trnd_11query2query	Eleventh query used in a trend
twelfth_query2trnd	OTM	trnd	trnd_12query2query	Twelfth query used in a trend
query2user	MTO	user	originator2query	User that originated/created query			Search (2)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
qry_name_index	query2user:obj_type:title	UNIQUE

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables
404	qry_owner	query, user
406	qry_grp_owner	qry_grp, query, user

My Recent Objects

query

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user