View HLPDTEST.STATEGPS.T_PROJECT_OPEN_ISSUES_STATUS_V | Generated by SchemaSpy |
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: