View Name:case_list
View Number:5680
Group:Support
Description:Used iSupport2.0 for case listing. Used in case_list.jsp
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
elm_objidvictimcase(case)objidCase internal record number 3 (UNIQUE)
supercase_objidsupercase(case)objidCase internal record number 
owner_objidowner(user)objidUser internal record number 
condition_objidconditionobjidCondition internal record number 
site_objidsiteobjidSite internal record number 
contact_objidcontactobjidUser internal record number 
gse_type_objidgse_type(gbst_elm)objidGbst_elm internal record number 
gse_prt_objidgse_priority(gbst_elm)objidGbst_elm internal record number 
gse_svt_objidgse_severity(gbst_elm)objidGbst_elm internal record number 
gse_status_objidgse_status(gbst_elm)objidGbst_elm internal record number 
id_numbervictimcase(case)id_numberUnique case number assigned based on auto-numbering definition 4
ownerowner(user)login_nameUser login name 12
conditionconditiontitleCondition of the case 7
statusgse_status(gbst_elm)titleStatus of the case 8
titlevictimcase(case)titleCase or service call title; summary of case details 2
site_namesitenameName of the reporting site 
first_namecontactfirst_nameContact first name 
last_namecontactlast_nameContact last name 
prioritygse_priority(gbst_elm)titlePriority of the case 35
severitygse_severity(gbst_elm)titleSeverity of the case 36
typegse_type(gbst_elm)titleType of case 37
is_supercasevictimcase(case)is_supercaseFlag if the case is a super case 
supercase_numsupercase(case)id_numberUnique case number if it is related to a super case 
creation_timevictimcase(case)creation_timeThe date and time the case was created 1

Joins:

Join FromJoin To
victimcase(case).case_owner2userowner(user).curr_owner2case
victimcase(case).case_state2condition(condition).case_condition2case
victimcase(case).calltype2gbst_elmgse_type(gbst_elm).call_type2case
victimcase(case).respprty2gbst_elmgse_priority(gbst_elm).resp_priority2case
victimcase(case).respsvrty2gbst_elmgse_severity(gbst_elm).resp_severity2case
victimcase(case).case_reporter2site(site).cust_loc2case
victimcase(case).case_reporter2contact(contact).caller2case
victimcase(case).casests2gbst_elmgse_status(gbst_elm).case_status2case
victimcase(case).case_victim2caseOUTER supercase(case).super2case
My Recent Objects
case_list