View HLPDTEST.STATEGPS.PROJECT_LINKED_TESTCASES_VW | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Apr 12 01:05 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,
T_GPS_APPLICATIONS APP, T_GPS_APP_PROPERTIES APP_PROP
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 = app.application_id
AND (APP.VISIBLE_FLAG = 'true' OR APP.VISIBLE_FLAG IS NULL)
AND APP_PROP.APPLICATION_ID = APP.APPLICATION_ID
AND APP_PROP.PROPERTY_NAME = 'RT_EXECUTION_TYPE'
AND APP_PROP.PROPERTY_VALUE ='PROJECT'
group by bsm.replay_sequence,maxtc.bsm_number,ins.application_id
Possibly Referenced Tables/Views:
![]() ![]() |