View Name:fc_filter_qry_favorites
View Number:4653
Group:Dovetail
Description:
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Custom

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
user_objiduserFavorite(user)objidThe objid of the user who has favorited the filter_query 
creator_loginuserOwner(user)login_nameThe login of the user who created the filter_query 
creator_first_nameemployeefirst_nameFirst name of the filter_query creator 
creator_last_nameemployeelast_nameFirst name of the filter_query creator 
sub_objidfilter_subobjidSubscription objid (if present) 
sub_is_acceptedfilter_subis_acceptedSubscription has been accepted (if present) 
sub_is_ignoredfilter_subis_ignoredSubscription has been ignored (if present) 
filter_query_objidfilter_queryobjidThe filter_query record objid 
titlefilter_querytitleThe title of the filter_query 
creation_timefilter_querycreation_timeWhen filter_query was created 
modify_stmpfilter_querymodify_stmpWhen filter_query was last modified 
is_globalfilter_queryis_globalIs this filter_query shared globally? 1=true 
is_systemfilter_queryis_systemIs this filter_query a system created query? 1=true 

Joins:

Join FromJoin To
(employee).employee2useruserOwner(user).user2employee
OUTER (filter_sub).filter_sub2filter_query(filter_query).filter_query2filter_sub
userFavorite(user).user2favorite_query(filter_query).favorite_query2user
(filter_query).filter_query2useruserOwner(user).user2filter_query
My Recent Objects
fc_filter_qry_favorites