Table Name:	queue
Table Number:	4
Group:	Workflow Mgr
Description:	Queue object that contains tasks awaiting transfer of ownership
Flags:
Baseline/Custom:	Baseline

select * from table_queue

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
allow_bug	LONG	tinyint			1	DIRECT	Indicates whether change requests are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow	Search (2)
allow_case	LONG	tinyint			1	DIRECT	Indicates whether cases are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow	Search (2)
allow_contract	LONG	tinyint			1	DIRECT	Indicates whether contracts/quotes are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow. Default is allow	Search (2)
allow_dialogue	LONG	tinyint			1	DIRECT	Indicates whether dialogues are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow. Default is allow	Search (2)
allow_dmnd_dtl	LONG	tinyint			1	DIRECT	Indicates whether part request are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow	Search (2)
allow_job	LONG	tinyint			1	DIRECT	Indicates whether jobs are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow. Default is allow	Search (1)
allow_opp	LONG	tinyint			1	DIRECT	Indicates whether opportunities are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow. Default is allow	Search (2)
allow_probdesc	LONG	tinyint			1	DIRECT	Indicates whether solutions are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow	Search (2)
allow_subcase	LONG	tinyint			1	DIRECT	Indicates whether subcase objects are allowed in the queue; i.e., 0=don't allow, 1=allow	Search (2)
allow_task	LONG	tinyint			1	DIRECT	Indicates whether tasks are allowed to be dispatched to the queue; i.e., 0=don't allow, 1=allow. Default is allow	Search (2)
department	CHAR	varchar		80			Reserved; not used
description	CHAR	varchar		255			Description of the queue	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dialog_id	LONG	int			376	DIRECT	Used to distinguish between ClearSupport & Logistics queues; default posts ClearSupport Queue form (728)
icon_id	LONG	int	16			DIRECT	Reserved; obsolete
legal_obj_type	LONG	int				DIRECT	Reserved; obsolete
max_resp_time	LONG	int				DIRECT	Reserved; obsolete
obj_accepted	LONG	int				DIRECT	Reserved; obsolete
obj_dispatched	LONG	int				DIRECT	Reserved; obsolete
obj_escalated	LONG	int				DIRECT	Reserved; obsolete
obj_forwarded	LONG	int				DIRECT	Reserved; obsolete
obj_received	LONG	int				DIRECT	Reserved; obsolete
obj_rejected	LONG	int				DIRECT	Reserved; obsolete
objid	LONG	int	3			DIRECT	Internal record number	Search (24)
shared_pers	LONG	int			1	DIRECT	Indicates whether the queue is shared or personal; i.e., 0=personal, 1=shared	Search (5)
sort_by	CHAR	varchar		80			Reserved; obsolete
title	CHAR	varchar	2	24			Queue title	Search (10)
x_res1	CHAR	varchar		20		USER_DEFINED	Restriction field
x_res2	CHAR	varchar		20		USER_DEFINED	Restriction field
x_res3	CHAR	varchar		20		USER_DEFINED	Restriction field
x_res4	CHAR	varchar		20		USER_DEFINED	Restriction field
x_res5	CHAR	varchar		20		USER_DEFINED	Restriction field

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Set Name	Type ID Stored in	Objid Stored In
							Exclusive Set Relations
queue2bug	OTM	bug	bug_currq2queue	Change requests currently dispatched to the queue
prevq2bug	OTM	bug	bug_prevq2queue	Change requests which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
prevq2case	OTM	case	case_prevq2queue	Cases which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
currq2case	OTM	case	case_currq2queue	Cases currently dispatched to the queue
prevq2contract	OTM	contract	contr_prevq2queue	Contracts which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
queue2contract	OTM	contract	contr_currq2queue	Queue the contract is dispatched to
prevq2demand_dtl	OTM	demand_dtl	demand_dtl_prvq2queue	Part request details which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
currq2demand_dtl	OTM	demand_dtl	demand_dtl_curq2queue	Queue part request is dispatched to
currq2dialogue	OTM	dialogue	dialogue_currq2queue	Dialogues currently dispatched to the queue
prevq2dialogue	OTM	dialogue	dialogue_prevq2queue	Dialogues which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
queue2dist_srvr	MTO	dist_srvr	dist_srvr2queue	Remote server the queue is connected to
queue2dt_task	OTM	dt_task	dt_task2queue	Tasks with a workflow item that dispatch to the queue	USER_DEFINED
queue2group	MTM	group	group_access2queue	Reserved; obsolete		mtm_queue7_ group3
prevq2job	OTM	job	job_prevq2queue	Jobs which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
currq2job	OTM	job	job_currq2queue	Jobs currently dispatched to the queue
queue2monitor	OTOP	monitor	monitor2queue	Reserved; obsolete
prevq2opportunity	OTM	opportunity	opp_prevq2queue	Opportunities which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
queue2opportunity	OTM	opportunity	opp_currq2queue	Queue the opportunity is dispatched to
queue2probdesc	OTM	probdesc	probdesc_q2queue	Solutions currently dispatched to the queue
prevq2probdesc	OTM	probdesc	probdesc_prevq2queue	Solutions which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
queue2queue_cc	OTM	queue_cc	queue_cc2queue	Reserved; obsolete
queue2rsrc	OTOF	rsrc	rsrc2queue	Resource representing the queue			route_to	focus_type	focus_lowid
prevq2subcase	OTM	subcase	subc_prevq2queue	Subcases which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
currq2subcase	OTM	subcase	subc_currq2queue	Subcases currently dispatched to the queue
prevq2task	OTM	task	task_prevq2queue	Tasks which were dispatched to the queue immediately prior to their current dispatch; used in temporary accept feature
queue2task	OTM	task	task_currq2queue	Tasks currently dispatched to the queue
queue2user	MTM	user	user_assigned2queue	Users assigned to the queue		mtm_queue4_ user23
queue_supvr2user	MTM	user	supvr_assigned2queue	Users supervising the queue. For personal queues, this is the queue owner		mtm_queue5_ user24
queue2workgroup	MTM	workgroup	workgroup2queue	Related workgroup(s)	USER_DEFINED	mtm_queue27_ workgroup0

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
queue_index	title	UNIQUE

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables
59	queelm_case	case, condition, gbst_elm, queue, site, user, workaround
60	queelm_subcase	condition, gbst_elm, queue, site, subcase, user
61	queelm_dtl	condition, demand_dtl, gbst_elm, mod_level, part_num, queue, user
65	queue_info	queue
97	queelm_fnl	condition, probdesc, queue
196	queelm_bug	bug, condition, gbst_elm, part_num, queue
382	que_element	case, condition, demand_dtl, gbst_elm, mod_level, part_num, queue
391	queued_case_dfe	case, condition, disptchfe, queue, user
392	subcase_queued_dfe	condition, disptchfe, queue, subcase, user
393	dfe_case_user	case, disptchfe, queue, user, wipbin
394	dfe_subcase_user	disptchfe, queue, subcase, user, wipbin
4629	fc_queelm_task	condition, gbst_elm, queue, task
4650	fc_user_case_view	case, condition, contact, employee, gbst_elm, queue, site, user, wipbin, workaround
4651	fc_user_subcase_view	case, condition, contact, employee, gbst_elm, queue, site, subcase, user, wipbin
4652	fc_user_solution_view	condition, employee, probdesc, queue, user
5038	queelm_contr	condition, contract, gbst_elm, queue
5044	queelm_opp	condition, gbst_elm, opportunity, queue
5088	queelm_task	condition, gbst_elm, queue, task
5329	queelm_dlg	condition, dialogue, gbst_elm, queue
5356	sfa_opp_wk_v	condition, gbst_elm, opportunity, queue, user, wipbin
5358	sfa_tsk_wk_v	condition, gbst_elm, queue, task, user, wipbin
5462	wap_case_info	address, case, condition, contact, contract, employee, gbst_elm, queue, site, site_part, user, wipbin
5739	case_overview	address, case, condition, contact, contact_role, contract, country, gbst_elm, mod_level, queue, site, site_part, user, workaround
5740	case_more_info	address, case, condition, contact, country, gbst_elm, queue, site, user, wipbin
5741	subcase_overview	case, condition, contact, gbst_elm, queue, subcase, user, wipbin
5749	queueelm_all	queue
5867	queue_details	queue
6018	schdl_tracker_sub_v2	address, case, disptchfe, employee, hgsl2hgse, queue, site, user, wipbin
6019	schdl_tracker_sub_v3	address, disptchfe, employee, hgsl2hgse, queue, site, subcase, user, wipbin
6020	schdl_tracker_sub_v4	address, disptchfe, employee, hgsl2hgse, queue, site, user
6021	schdl_tracker_sub_v5	address, disptchfe, employee, hgsl2hgse, queue, site, user
6026	queueelm_demanddtl	condition, demand_dtl, gbst_elm, queue

My Recent Objects

queue

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog