View Name:qry_grp_owner
View Number:406
Group:Info retrieval
Description:View for query owner. Used by form Define Query Icon (809)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidqueryobjidInternal record number 3 (UNIQUE)
grp_objidqry_grpobjidQuery group internal record number 
titlequerytitleName of the query 
grp_titleqry_grptitleQuery group title 
owner_objiduserobjidQuery owner's objid 
owner_loginuserlogin_nameQuery owner's login 
obj_typequeryobj_typeObject type ID the query is for; i.e., case=0,subcase=24,change request=192, or solution=1 
view_typequeryview_typeSchema view being used for query; differs based on object type 
default_valquerydefault_valIndicates whether the query invokes properties, keyphrases, or both 
stored_prc_namequerystored_prc_nameReserved for the name of the stored procedure for this query 
sql_statementquerysql_statementSQL code created based on parameters entered by user for this query 
keyword_modequerykeyword_modeIf using keywords, match All or Any 
order_valqueryorder_valAscending or descending sort criteria 
shared_persqueryshared_persIndicates whether the query is shareable with users other than the originator; i.e., 0=private, 1=shareable, default=0 
shared_pers_stqueryshared_pers_stTranslates shared_pers 
prompt_indqueryprompt_ind0=no prompt, 1=prompt 
prompt_ind_stqueryprompt_ind_stTranslates prompt_ind 

Joins:

Join FromJoin To
(query).query2user(user).originator2query
(qry_grp).qry_grp2query(query).query2qry_grp
My Recent Objects
qry_grp_owner