View HLPDTEST.STATEGPS.T_PROJECT_OPEN_ISSUES_STATUS_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
USER_NAME varchar2 255  √  null
APPLICATION_NAME varchar2 255  √  null
PROPERTY varchar2 19  √  null
VALUE number 22  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
SELECT u.user_name, created_issues.application_name, 'Non Promised Issues' property, COUNT(issues2.issue_id) value FROM STATEGPS.T_ISSUES_CREATED_BY_ME_V created_issues, t_gps_user_applications ua, t_gps_user_menuconfig um, t_gps_users u, tri2gps_dev.issues issues2 WHERE created_issues.STATE_NAME <> 'Issue Closed' AND created_issues.ACTIVE = 'Active' AND created_issues.application_id = ua.application_id AND ua.user_app_id = um.user_app_id AND um.menu_name = 'Build' AND ua.user_id = u.user_id --AND u.user_name = 'lchinta' --and created_issues.application_name = 'Triniti Products' AND IA_ISSUE_NUMBER IS NOT NULL AND issues2.DUE_DATE IS NULL AND issues2.ISSUE_NUMBER = created_issues.IA_ISSUE_NUMBER group by u.user_name,created_issues.application_name union SELECT u.user_name,created_issues.application_name, 'Backlog Issues' property, COUNT(issues2.issue_id) value FROM STATEGPS.T_ISSUES_CREATED_BY_ME_V created_issues, t_gps_user_applications ua, t_gps_user_menuconfig um, t_gps_users u, tri2gps_dev.issues issues2 WHERE created_issues.STATE_NAME <> 'Issue Closed' AND created_issues.ACTIVE = 'Active' AND created_issues.application_id = ua.application_id AND ua.user_app_id = um.user_app_id AND um.menu_name = 'Build' AND ua.user_id = u.user_id AND u.user_name = 'lchinta' --and created_issues.application_name = 'Triniti Products' AND IA_ISSUE_NUMBER IS NOT NULL AND TRUNC(issues2.DUE_DATE) < SYSDATE AND issues2.ISSUE_NUMBER = created_issues.IA_ISSUE_NUMBER GROUP BY u.user_name,created_issues.application_name
 
Possibly Referenced Tables/Views: