View HLPDTEST.STATEGPS.ISSUE_PROJECT_LINKED_TC_VW | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||
Analyzed at Tue Jan 26 01:06 IST 2021 |
View Definition:
select max(maxtc.case_id) case_id,bsm.replay_sequence,ins.application_id
from t_instances ins,
v_instance_props prop,
tri2gps_dev.links links,
tri2gps_dev.issues iss,
tri2gps_dev.test_cases tc,
tri2gps_dev.test_Cases maxtc,
tri2gps_dev.bsm_main bsm
where prop.INSTANCE_ID = ins.instance_id
and links.reference_type like 'TC'
and links.link_type = 'ISS'
and iss.issue_id = links.entity_id
and tc.case_id = links.reference_identifier
and maxtc.bsm_number = tc.bsm_number
and iss.issue_number = prop.IA_ISSUE_NUMBER
and maxtc.bsm_number = bsm.bsm_number
--and ins.application_id = 1039
group by bsm.replay_sequence,maxtc.bsm_number,ins.application_id
Possibly Referenced Tables/Views:
![]() ![]() |