View HLPDTEST.STATEGPS.T_OPEN_ISSUES_PER_PRIORITY_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
PRIORITY_ORDER number 22  √  null
PRIORITY_TYPE varchar2 19  √  null
NO_ISSUES number 22  √  null
PROJECT_ID number 22  √  null
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R
PROJECT_NAME varchar2 255  √  null

Analyzed at Tue Aug 11 01:05 IST 2020

View Definition:
SELECT 1 priority_order, 'Very High (0 to 10)' priority_type, COUNT(1) NO_ISSUES, a.application_id PROJECT_ID, a.application_name PROJECT_NAME FROM t_gps_workflow_states ws, t_gps_instances gi, t_instances i, t_gps_applications a, t_gps_workflow_types wt WHERE state_descriptor not in ('Workflow End','AND State') AND gi.instance_present = 1 AND gi.active = 1 AND ws.state_id = gi.current_state_id AND gi.instance_id = i.instance_id AND wt.application_id = a.application_id and ws.workflow_type_id = wt.workflow_type_id AND i.priority BETWEEN 0 AND 10 --and i.application_id=2600 --and i.application_id=2599 GROUP BY a.application_id, a.application_name UNION SELECT 2 priority_order, 'High (11 to 50)' priority_type, COUNT(1) NO_ISSUES, a.application_id PROJECT_ID, a.application_name PROJECT_NAME FROM t_gps_workflow_states ws, t_gps_instances gi, t_instances i, t_gps_applications a, t_gps_workflow_types wt WHERE state_descriptor not in ('Workflow End','AND State') AND gi.instance_present = 1 AND gi.active = 1 AND ws.state_id = gi.current_state_id AND gi.instance_id = i.instance_id AND wt.application_id = a.application_id and ws.workflow_type_id = wt.workflow_type_id AND i.priority BETWEEN 11 AND 50 --and i.application_id=2600 GROUP BY a.application_id, a.application_name UNION SELECT 3 priority_order, 'Medium (51 to 99)' priority_type, COUNT(1) NO_ISSUES, a.application_id PROJECT_ID, a.application_name PROJECT_NAME FROM t_gps_workflow_states ws, t_gps_instances gi, t_instances i, t_gps_applications a, t_gps_workflow_types wt WHERE state_descriptor not in ('Workflow End','AND State') AND gi.instance_present = 1 AND gi.active = 1 AND ws.state_id = gi.current_state_id AND gi.instance_id = i.instance_id AND wt.application_id = a.application_id and wt.workflow_type_id = ws.workflow_type_id AND i.priority BETWEEN 51 AND 99 --and i.application_id=2600 GROUP BY a.application_id, a.application_name UNION SELECT 4 priority_order, 'Low (100 to 999)' priority_type, COUNT(1) NO_ISSUES, a.application_id PROJECT_ID, a.application_name PROJECT_NAME FROM t_gps_workflow_states ws, t_gps_instances gi, t_instances i, t_gps_applications a, t_gps_workflow_types wt WHERE state_descriptor not in ('Workflow End','AND State') AND gi.instance_present = 1 AND gi.active = 1 AND ws.state_id = gi.current_state_id AND gi.instance_id = i.instance_id AND wt.application_id = a.application_id and ws.workflow_type_id = wt.workflow_type_id AND i.priority BETWEEN 100 AND 999 --and i.application_id=2600 GROUP BY a.application_id, a.application_name ORDER BY 1
 
Possibly Referenced Tables/Views:


Close relationships: