Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
age	CLK_TIME	datetime					Creation date and time of the probdesc object
age_str	CHAR	varchar		32			To display elapsed time of a workflow object in queue
condition	CHAR	varchar		80			Title of condition
creation_date	CLK_TIME	datetime					Dummy field use for temporary value
dev	LONG	int	151			DIRECT	Row version number for mobile distribution purposes
elm_objid	LONG	int				DIRECT	Queue element internal record number
idnum	CHAR	varchar		32			Unique ID number
objid	LONG	int	3			DIRECT	Internal record number
owner	CHAR	varchar		24			???
priority	CHAR	varchar		32			Dummy field use to store a temporary value
que_objid	LONG	int				DIRECT	Queue element internal record number
queue_type	CHAR	varchar		32			Dummy field use to store a temporary value
status	CHAR	varchar		32			Dummy field use to store a temporary value
struct_type	LONG	int				DIRECT	Dummy field use to store a temporary value
title	CHAR	varchar		24			Queue title

SQL:

(
select elm_objid as objid, '0' as queue_type, ' ' as age_str, -1 as dev,que_objid, 8 as elm_objid, age, start_date as creation_date, condition, status, title, '' as priority, id as idnum, '' as owner, -1 as struct_type from table_queelm_task
union
select o.elm_objid as objid,'1' as queue_type,' ' as age_str,-1 as dev,o.que_objid,2 as elm_objid,o.age, c.creation_time as creation_date,o.condition,o.status,o.title,o.priority,o.id_number as idnum,'' as owner,-1 as struct_type from table_queelm_case o,table_case c where c.objid=o.elm_objid
union
select elm_objid as objid,'2' as queue_type,' ' as age_str,-1 as dev,n.que_objid,1 as elm_objid,n.age,b.creation_time as creation_date,n.condition,n.status,n.title,n.priority,n.id_number as idnum,'' as owner, -1 as struct_type from table_queelm_bug n,table_bug b where b.objid=n.elm_objid
union
select elm_objid as objid, '3' as queue_type, ' ' as age_str,-1 as dev, que_objid, 3 as elm_objid, age, create_dt as creation_date, condition, table_queelm_contr.status, table_queelm_contr.title, '' as priority, table_queelm_contr.id as idnum, '' as owner,table_contract.struct_type as struct_type from table_queelm_contr, table_contract where table_contract.objid = table_queelm_contr.elm_objid and table_queelm_contr.struct_type=0
union
select elm_objid as objid,'4' as queue_type,' ' as age_str,-1 as dev,que_objid,4 as elm_objid,age,e.creation_time as creation_date,condition, status,e.title,priority,id as idnum,'' as owner,-1 as struct_type from table_queelm_dlg p,table_dialogue e where e.objid=p.elm_objid
union
select elm_objid as objid, '5' as queue_type, ' ' as age_str, -1 as dev,que_objid, 6 as elm_objid, age, update_stamp as creation_date, condition, status, name as title, '' as priority, id as idnum, '' as owner,-1 as struct_type from table_queelm_opp
union
select elm_objid as objid, '6' as queue_type, ' ' as age_str,-1 as dev, que_objid, 3 as elm_objid, age, create_dt as creation_date, condition, table_queelm_contr.status, table_queelm_contr.title, '' as priority, table_queelm_contr.id as idnum, '' as owner,table_contract.struct_type as struct_type from table_queelm_contr, table_contract where table_contract.objid = table_queelm_contr.elm_objid and table_queelm_contr.struct_type=4
union
select objid, '61' as queue_type, ' ' as age_str, -1 as dev, que_objid, 9 as elm_objid, age, creation_date, condition, status, title, priority, idnum, '' as owner,-1 as struct_type from table_queueelm_demanddtl
union
select elm_objid as objid, '7' as queue_type, ' ' as age_str,-1 as dev, que_objid, 3 as elm_objid, age, create_dt as creation_date, condition, table_queelm_contr.status, table_queelm_contr.title, '' as priority, table_queelm_contr.id as idnum, '' as owner,table_contract.struct_type as struct_type from table_queelm_contr, table_contract where table_contract.objid = table_queelm_contr.elm_objid and table_queelm_contr.struct_type=1
union
select elm_objid as objid, '8' as queue_type, ' ' as age_str, -1 as dev,que_objid, 5 as elm_objid, age, table_probdesc.creation_time as creation_date, condition, '' as status, table_probdesc.title, '' as priority,
table_probdesc.id_number as idnum, '' as owner,-1 as struct_type from table_queelm_fnl, table_probdesc where table_probdesc.objid = table_queelm_fnl.elm_objid
union
select elm_objid as objid, '9' as queue_type, ' ' as age_str, -1 as dev,que_objid, 7 as elm_objid, age, table_subcase.creation_time as creation_date, condition, status, table_subcase.title, priority, table_subcase.id_number as idnum, '' as owner,-1 as struct_type from table_queelm_subcase, table_subcase where table_subcase.objid = table_queelm_subcase.elm_objid
)