View Name:subcase_al
View Number:39
Group:Support
Description:Selects events on a subcase
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
entry_timeact_entryentry_timeDate and time of activity log entry 1
act_codeact_entryact_codeActivity code 10
add_infoact_entryaddnl_infoAdditional information such as notes 11
login_nameuserlogin_nameLogin name of the user that made the activity log entry 12
parent_objidsubcaseobjidUnique object ID number of parent object 13
objidact_entryobjidUnique object ID number of object 3 (UNIQUE)
act_namegbst_elmtitleActivity Name 2
gsl_namegbst_lsttitleName of the Clarify-defined pop up list on which act name is found 

Joins:

Join FromJoin To
(act_entry).act_entry2subcase(subcase).subcase2act_entry
(act_entry).act_entry2user(user).originator2act_entry
(act_entry).entry_name2gbst_elm(gbst_elm).act_name2act_entry
(gbst_elm).gbst_elm2gbst_lst(gbst_lst).gbst_lst2gbst_elm
My Recent Objects
subcase_al