| View Name: | fc_filter_qry_favorites |
| View Number: | 4653 |
| Group: | Dovetail |
| Description: | |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Custom |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| creation_time | filter_query | creation_time | When filter_query was created | |
| creator_first_name | employee | first_name | First name of the filter_query creator | |
| creator_last_name | employee | last_name | First name of the filter_query creator | |
| creator_login | userOwner(user) | login_name | The login of the user who created the filter_query | |
| filter_query_objid | filter_query | objid | The filter_query record objid | |
| is_global | filter_query | is_global | Is this filter_query shared globally? 1=true | |
| is_system | filter_query | is_system | Is this filter_query a system created query? 1=true | |
| modify_stmp | filter_query | modify_stmp | When filter_query was last modified | |
| sub_is_accepted | filter_sub | is_accepted | Subscription has been accepted (if present) | |
| sub_is_ignored | filter_sub | is_ignored | Subscription has been ignored (if present) | |
| sub_objid | filter_sub | objid | Subscription objid (if present) | |
| title | filter_query | title | The title of the filter_query | |
| user_objid | userFavorite(user) | objid | The objid of the user who has favorited the filter_query |
Join From | Join To |
|---|---|
| (employee).employee2user | userOwner(user).user2employee |
| OUTER (filter_sub).filter_sub2filter_query | (filter_query).filter_query2filter_sub |
| userFavorite(user).user2favorite_query | (filter_query).favorite_query2user |
| (filter_query).filter_query2user | userOwner(user).user2filter_query |
| fc_filter_qry_favorites | |||