View HLPDTEST.STATEGPS.T_MONTHLY_OPEN_CLOSED_ISSUES_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
PROJECT varchar2 255  √  null
WORKFLOW_TYPE_NAME varchar2 255  √  null
TICKET_DATE date 7  √  null
STATUS varchar2 6  √  null
INSTANCE_ID number 22  √  null
T_INSTANCES.INSTANCE_ID Implied Constraint R

Analyzed at Sun Sep 27 01:05 IST 2020

View Definition:
select a.application_id,a.application_name PROJECT, wt.workflow_type_name, trunc(i.creation_date,'MM') TICKET_DATE, 'OPEN' STATUS, i.instance_id INSTANCE_ID from t_instances i, t_gps_applications a, t_gps_instances gi, t_gps_workflow_types wt, t_project_task pt where gi.WORKFLOW_TYPE_ID = wt.WORKFLOW_TYPE_ID and a.application_id = i.application_id and a.visible_flag = 'true' and i.instance_id = gi.instance_id and gi.active = 1 and pt.instance_id = i.instance_id and pt.state_id = gi.current_state_id union select a.application_id,a.application_name PROJECT, wt.workflow_type_name, trunc(gi.created_date,'MM') TICKET_DATE, 'CLOSED' STATUS, gi.instance_id INSTANCE_ID from t_gps_instances gi, t_gps_workflow_states ws, t_gps_applications a, t_gps_workflow_types wt, t_gps_workflow_states ws1 where gi.workflow_type_id = wt.WORKFLOW_TYPE_ID and gi.current_state_id = ws.state_id and gi.application_id = a.application_id and a.visible_flag = 'true' and ws.state_descriptor = 'Workflow End' and gi.active = 1 -- newly added conditions to resolve issue if parent and child workflows has adjacent ends and gi.from_state_id = ws1.state_id and ws1.state_descriptor != 'Workflow' -- End of newly added conditions
 
Possibly Referenced Tables/Views:


Close relationships: