Banco de Dados - Query
Por: andersonrds • 3/4/2016 • Artigo • 485 Palavras (2 Páginas) • 225 Visualizações
SELECT
RE.REL_NAME AS VERSAO
,rc.RCYC_NAME AS 'CICLO'
,TS.TS_TEST_ID AS ID_Cenario
,TS.TS_NAME AS CASO_DE_TESTE
,TC.TC_STATUS AS STATUS_CASO_TESTE
,BG.BG_BUG_ID AS Defeito
,BG.BG_STATUS AS STATUS_BUG
,BG.BG_USER_TEMPLATE_11 AS ATRIBUIDO_A
FROM bug bg
INNER join link lnk on lnk.ln_bug_id = bg.BG_BUG_ID
inner join step on ln_entity_id = st_id
INNER join run as rn on rn.rn_run_id = st_run_id
inner join test ts ON TS.TS_TEST_ID = RN.RN_TEST_ID
inner join cycle as ca on ca.cy_cycle_id = rn.rn_cycle_id
inner join releases as re on re.REL_ID = BG.BG_DETECTED_IN_REL
INNER JOIN TESTCYCL as tc on tc.tc_testcycl_id = rn.rn_testcycl_id
join RELEASE_CYCLES as rc on rc.RCYC_ID = BG.BG_DETECTED_IN_RCYC
WHERE
RE.REL_NAME = 'Frente 4 DCD PJ' or
RE.REL_NAME = 'Frente 4 DCD Projetos' or
RE.REL_NAME = 'Frente 4 DCPS' or
RE.REL_NAME = 'Frente 4 Segurança Corporativa' or
RE.REL_NAME = 'Frente 5 DCD PJ' or
RE.REL_NAME = 'Frente 5 DCD Projetos' or
RE.REL_NAME = 'Frente 5 DCPS' or
RE.REL_NAME = 'Frente 5 Segurança Corporativa' or
RE.REL_NAME = 'OBB Plus' or
RE.REL_NAME = 'Piloto Controlado - Grupo Economico'
ORDER BY 1,2,3
0u
SELECT
RE.REL_NAME AS VERSAO
,rc.RCYC_NAME AS 'CICLO'
,TS.TS_TEST_ID AS ID_Cenario
,TS.TS_NAME AS CASO_DE_TESTE
,TC.TC_STATUS AS STATUS_CASO_TESTE
,BG.BG_BUG_ID AS Defeito
,BG.BG_STATUS AS STATUS_BUG
,BG.BG_USER_TEMPLATE_11 AS ATRIBUIDO_A
FROM bug bg
INNER join link lnk on lnk.ln_bug_id = bg.BG_BUG_ID
inner join step on ln_entity_id
...