View Name:subcase_list
View Number:5679
Group:Support
Description:Subcase list. Used by iSupport2.0 for subcase listing. Used in case_subcase.jsp
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
case_objidcaseobjidCase internal record number 
elm_objidsubcaseobjidSubcase internal record number 3 (UNIQUE)
condition_objidconditionobjidCondition internal record number 
gbst_elm_objidgbst_elmobjidGbst_elm internal record number 
clarify_stateconditionconditionCode number for condition type 8
user_objiduserobjidUser internal record number 
behaviorsubcasebehaviorInternal field indicating the behavior of the subcase type; i.e., 1=normal, 2=administrative subcase 31
id_numbersubcaseid_numberUnique ID number for the subcase; consists of case number-# 4
owneruserlogin_nameUser login name 
conditionconditiontitleTitle of condition 7
statusgbst_elmtitleName of the item/element 17
titlesubcasetitleSubcase title 2
sub_typesubcasesub_typeSubcase type; general or administrative 32
creation_timesubcasecreation_timeThe date and time the subcase was created 1
required_datesubcaserequired_dateDate and time task must be completed 

Joins:

Join FromJoin To
(subcase).subcase2case(case).case2subcase
(subcase).subc_owner2user(user).curr_owner2subcase
(subcase).subc_state2condition(condition).subc_conditn2subcase
(subcase).subc_casests2gbst_elm(gbst_elm).case_status2subcase
My Recent Objects
subcase_list