L'Informe de Resultat de les Proves es basa en la plantilla disponible a Assumpte_IN_RPx_V2.0.docx Una vegada descarregada alguns dels apartats es generen automàticament a partir de la informació continguda a HP QC. Veure a continuació com incloure els fragments automàtics.
Des de la pestanya ‘Configuration’ situar-se a ‘Query’ i copiar el següent contingut:
/* SQL Query to get the details of Test Cases and Requirements from a RELEASE in HP ALM */
/* NO INCLOSES: TIPUS PROVA (TS_USER_02) = Auditoria */
/* NO INCLOSES: NIVELL DE PROVA(TS_USER_01) = Revisió */
SELECT
B.rel_name AS "Versió",
B.RCYC_NAME AS "Build",
B.TS_USER_01 AS "Nivell Prova",
B.CY_CYCLE as "Escenari",
B.TS_TEST_ID AS "ID.",
B.TS_NAME AS "Nom Prova",
A.TS_DESCRIPTION AS "Descripció",
B.TS_USER_02 AS "Tipus Prova",
B.requisits AS "Requisits",
B.TS_STATUS AS "StatusTest",
B.Comentari AS "Comentari",
//RUN.RN_COMMENTS AS "Comentari",
//B.Comentari AS "Comentari",
//A.TS_DEV_COMMENTS AS "Comentari",
//A.TS_VC_CHECKIN_COMMENTS AS "Comentari",
B.Resultat AS "StatusResult",
CASE WHEN (B.TS_USER_02 = 'Rendiment') THEN 'Automàtica'
ELSE CASE WHEN (B.TS_USER_02 <> 'Rendiment' and A.TS_TYPE = 'QUICKTEST-TEST') THEN 'Automàtica'
ELSE CASE WHEN (A.TS_TYPE <> 'QUICKTEST-TEST') THEN 'Manual'
END END END AS "Tipus Exec"
FROM
TEST A,
(
SELECT DISTINCT
rel_name,
TEST.TS_TEST_ID,
TEST.TS_NAME,
RELEASE_CYCLES.RCYC_NAME,
CYCLE.CY_CYCLE,
TEST.TS_USER_02,
TEST.TS_USER_01,
RUN.RN_TEST_ID,
DBMS_LOB.substr(RUN.RN_COMMENTS, 3000) AS Comentari,
//RUN.RN_COMMENTS AS "Comentari"
//DBMS_LOB.substr(TEST.TS_DEV_COMMENTS, 3000),
CASE WHEN (TEST.TS_EXEC_STATUS = 'Passed') THEN 'Passed' END AS Resultat,
TEST.TS_STATUS,
requisits,
CASE WHEN (TEST.TS_USER_01='Unitàries') THEN 1
ELSE CASE WHEN (TEST.TS_USER_01='Integració') THEN 2
ELSE CASE WHEN (TEST.TS_USER_01='Qualificació') THEN 3
ELSE CASE WHEN (TEST.TS_USER_01='Acceptació') THEN 4
ELSE CASE WHEN (TEST.TS_USER_01='Revisió') THEN 5
END END END END END AS NrNP
FROM TEST
LEFT JOIN testcycl on testcycl.tc_test_id=test.ts_test_id
LEFT JOIN run on run.rn_test_id = test.ts_test_id
LEFT JOIN cycle on cycle.cy_cycle_id=testcycl.tc_cycle_id
LEFT JOIN release_cycles on release_cycles.rcyc_id= cycle.cy_assign_rcyc
LEFT JOIN releases on releases.rel_id = release_cycles.rcyc_parent_id,
(SELECT TEST.TS_TEST_ID as req_prova_id, LISTAGG(REQ.RQ_REQ_ID, '; ') WITHIN GROUP (ORDER BY REQ.RQ_REQ_ID) AS requisits
FROM TEST
LEFT JOIN REQ_COVER on REQ_COVER.RC_ENTITY_ID=TEST.TS_TEST_ID
LEFT JOIN REQ on REQ_COVER.RC_REQ_ID=REQ.RQ_REQ_ID
GROUP BY TEST.TS_TEST_ID )
WHERE req_prova_id=TEST.TS_TEST_ID and RCYC_NAME=@Build@ and TEST.TS_EXEC_STATUS='Passed'
/* and TEST.TS_USER_02 <> 'Auditoria' and TEST.TS_USER_01 <>'Revisió' */
) B
WHERE A.TS_TEST_ID = B.TS_TEST_ID
ORDER BY B.RCYC_NAME, B.NrNP, B.TS_USER_02
Prémer ‘Query Builder’ i a la pestanya ‘Query Parameters’ de a sota, prémer el botó d’afegir paràmetre (
) i incloure un paràmetre amb el nom ‘Build’ amb el valor per defecte ‘0.0.0.B001’.
Des de la pestanya ‘Configuration’ situar-se a ‘Query’ i prémer el botó ‘Generate’.
Incrustar el fitxer generat en l’informe de resultats
Des de la pestanya ‘Configuration’ situar-se a ‘Query’ i copiar el següent contingut:
/* SQL Query to get the details of Test Cases and Requirements from a RELEASE in HP ALM */
/* NO INCLOSES: TIPUS PROVA (TS_USER_02) = Auditoria */
/* NO INCLOSES: NIVELL DE PROVA(TS_USER_01) = Revisió */
SELECT
B.rel_name AS "Versió",
B.RCYC_NAME AS "Build",
B.TS_USER_01 AS "Nivell Prova",
B.CY_CYCLE as "Escenari",
B.TS_TEST_ID AS "ID.",
B.TS_NAME AS "Nom Prova",
A.TS_DESCRIPTION AS "Descripció",
B.TS_USER_02 AS "Tipus Prova",
B.requisits AS "Requisits",
B.TS_STATUS AS "StatusTest",
B.Comentari AS "Comentari",
//RUN.RN_COMMENTS AS "Comentari",
//B.Comentari AS "Comentari",
//A.TS_DEV_COMMENTS AS "Comentari",
//A.TS_VC_CHECKIN_COMMENTS AS "Comentari",
B.Resultat AS "StatusResult",
CASE WHEN (B.TS_USER_02 = 'Rendiment') THEN 'Automàtica'
ELSE CASE WHEN (B.TS_USER_02 <> 'Rendiment' and A.TS_TYPE = 'QUICKTEST-TEST') THEN 'Automàtica'
ELSE CASE WHEN (A.TS_TYPE <> 'QUICKTEST-TEST') THEN 'Manual'
END END END AS "Tipus Exec"
FROM
TEST A,
(
SELECT DISTINCT
rel_name,
TEST.TS_TEST_ID,
TEST.TS_NAME,
RELEASE_CYCLES.RCYC_NAME,
CYCLE.CY_CYCLE,
TEST.TS_USER_02,
TEST.TS_USER_01,
RUN.RN_TEST_ID,
DBMS_LOB.substr(RUN.RN_COMMENTS, 3000) AS Comentari,
//RUN.RN_COMMENTS AS "Comentari"
//DBMS_LOB.substr(TEST.TS_DEV_COMMENTS, 3000),
CASE WHEN (TEST.TS_EXEC_STATUS = 'Blocked') THEN 'Blocked' END AS Resultat,
TEST.TS_STATUS,
requisits,
CASE WHEN (TEST.TS_USER_01='Unitàries') THEN 1
ELSE CASE WHEN (TEST.TS_USER_01='Integració') THEN 2
ELSE CASE WHEN (TEST.TS_USER_01='Qualificació') THEN 3
ELSE CASE WHEN (TEST.TS_USER_01='Acceptació') THEN 4
ELSE CASE WHEN (TEST.TS_USER_01='Revisió') THEN 5
END END END END END AS NrNP
FROM TEST
LEFT JOIN testcycl on testcycl.tc_test_id=test.ts_test_id
LEFT JOIN run on run.rn_test_id = test.ts_test_id
LEFT JOIN cycle on cycle.cy_cycle_id=testcycl.tc_cycle_id
LEFT JOIN release_cycles on release_cycles.rcyc_id= cycle.cy_assign_rcyc
LEFT JOIN releases on releases.rel_id = release_cycles.rcyc_parent_id,
(SELECT TEST.TS_TEST_ID as req_prova_id, LISTAGG(REQ.RQ_REQ_ID, '; ') WITHIN GROUP (ORDER BY REQ.RQ_REQ_ID) AS requisits
FROM TEST
LEFT JOIN REQ_COVER on REQ_COVER.RC_ENTITY_ID=TEST.TS_TEST_ID
LEFT JOIN REQ on REQ_COVER.RC_REQ_ID=REQ.RQ_REQ_ID
GROUP BY TEST.TS_TEST_ID )
WHERE req_prova_id=TEST.TS_TEST_ID and RCYC_NAME=@Build@ and TEST.TS_EXEC_STATUS='Blocked'
/* and TEST.TS_USER_02 <> 'Auditoria' and TEST.TS_USER_01 <>'Revisió' */
) B
WHERE A.TS_TEST_ID = B.TS_TEST_ID
ORDER BY B.RCYC_NAME, B.NrNP, B.TS_USER_02
Prémer ‘Query Builder’ i a la pestanya ‘Query Parameters’ de a sota, prémer el botó d’afegir paràmetre (
) i incloure un paràmetre amb el nom ‘Build’ amb el valor per defecte ‘0.0.0.B001’.
Des de la pestanya ‘Configuration’ situar-se a ‘Query’ i prémer el botó ‘Generate’.
Incrustar el fitxer generat en l’informe de resultats
Des de la pestanya ‘Configuration’ situar-se a ‘Query’ i copiar el següent contingut:
/* SQL Query to get the details of Test Cases and Requirements from a RELEASE in HP ALM */
/* NO INCLOSES: TIPUS PROVA (TS_USER_02) = Auditoria */
/* NO INCLOSES: NIVELL DE PROVA(TS_USER_01) = Revisió */
SELECT
B.rel_name AS "Versió",
B.RCYC_NAME AS "Build",
B.TS_USER_01 AS "Nivell Prova",
B.CY_CYCLE as "Escenari",
B.TS_TEST_ID AS "ID.",
B.TS_NAME AS "Nom Prova",
A.TS_DESCRIPTION AS "Descripció",
B.TS_USER_02 AS "Tipus Prova",
B.requisits AS "Requisits",
B.TS_STATUS AS "StatusTest",
B.Comentari AS "Comentari",
//RUN.RN_COMMENTS AS "Comentari",
//B.Comentari AS "Comentari",
//A.TS_DEV_COMMENTS AS "Comentari",
//A.TS_VC_CHECKIN_COMMENTS AS "Comentari",
B.Resultat AS "StatusResult",
CASE WHEN (B.TS_USER_02 = 'Rendiment') THEN 'Automàtica'
ELSE CASE WHEN (B.TS_USER_02 <> 'Rendiment' and A.TS_TYPE = 'QUICKTEST-TEST') THEN 'Automàtica'
ELSE CASE WHEN (A.TS_TYPE <> 'QUICKTEST-TEST') THEN 'Manual'
END END END AS "Tipus Exec"
FROM
TEST A,
(
SELECT DISTINCT
rel_name,
TEST.TS_TEST_ID,
TEST.TS_NAME,
RELEASE_CYCLES.RCYC_NAME,
CYCLE.CY_CYCLE,
TEST.TS_USER_02,
TEST.TS_USER_01,
RUN.RN_TEST_ID,
DBMS_LOB.substr(RUN.RN_COMMENTS, 3000) AS Comentari,
//RUN.RN_COMMENTS AS "Comentari"
//DBMS_LOB.substr(TEST.TS_DEV_COMMENTS, 3000),
CASE WHEN (TEST.TS_EXEC_STATUS = 'No Run') THEN 'No Run' END AS Resultat,
TEST.TS_STATUS,
requisits,
CASE WHEN (TEST.TS_USER_01='Unitàries') THEN 1
ELSE CASE WHEN (TEST.TS_USER_01='Integració') THEN 2
ELSE CASE WHEN (TEST.TS_USER_01='Qualificació') THEN 3
ELSE CASE WHEN (TEST.TS_USER_01='Acceptació') THEN 4
ELSE CASE WHEN (TEST.TS_USER_01='Revisió') THEN 5
END END END END END AS NrNP
FROM TEST
LEFT JOIN testcycl on testcycl.tc_test_id=test.ts_test_id
LEFT JOIN run on run.rn_test_id = test.ts_test_id
LEFT JOIN cycle on cycle.cy_cycle_id=testcycl.tc_cycle_id
LEFT JOIN release_cycles on release_cycles.rcyc_id= cycle.cy_assign_rcyc
LEFT JOIN releases on releases.rel_id = release_cycles.rcyc_parent_id,
(SELECT TEST.TS_TEST_ID as req_prova_id, LISTAGG(REQ.RQ_REQ_ID, '; ') WITHIN GROUP (ORDER BY REQ.RQ_REQ_ID) AS requisits
FROM TEST
LEFT JOIN REQ_COVER on REQ_COVER.RC_ENTITY_ID=TEST.TS_TEST_ID
LEFT JOIN REQ on REQ_COVER.RC_REQ_ID=REQ.RQ_REQ_ID
GROUP BY TEST.TS_TEST_ID )
WHERE req_prova_id=TEST.TS_TEST_ID and RCYC_NAME=@Build@ and TEST.TS_EXEC_STATUS='No Run'
/* and TEST.TS_USER_02 <> 'Auditoria' and TEST.TS_USER_01 <>'Revisió' */
) B
WHERE A.TS_TEST_ID = B.TS_TEST_ID
ORDER BY B.RCYC_NAME, B.NrNP, B.TS_USER_02
Prémer ‘Query Builder’ i a la pestanya ‘Query Parameters’ de a sota, prémer el botó d’afegir paràmetre (
) i incloure un paràmetre amb el nom ‘Build’ amb el valor per defecte ‘0.0.0.B001’.
Des de la pestanya ‘Configuration’ situar-se a ‘Query’ i prémer el botó ‘Generate’.
Incrustar el fitxer generat en l’informe de resultats
Des de la pestanya ‘Configuration’ situar-se a ‘Query’ i copiar el següent contingut:
/* SQL Query to get the details of Test Cases and Requirements from a RELEASE in HP ALM */
/* NO INCLOSES: TIPUS PROVA (TS_USER_02) = Auditoria */
/* NO INCLOSES: NIVELL DE PROVA(TS_USER_01) = Revisió */
SELECT
B.rel_name AS "Versió",
B.RCYC_NAME AS "Build",
B.TS_USER_01 AS "Nivell Prova",
B.CY_CYCLE as "Escenari",
B.TS_TEST_ID AS "ID.",
B.TS_NAME AS "Nom Prova",
A.TS_DESCRIPTION AS "Descripció",
B.TS_USER_02 AS "Tipus Prova",
B.requisits AS "Requisits",
B.TS_STATUS AS "StatusTest",
B.Comentari AS "Comentari",
//RUN.RN_COMMENTS AS "Comentari",
//B.Comentari AS "Comentari",
//A.TS_DEV_COMMENTS AS "Comentari",
//A.TS_VC_CHECKIN_COMMENTS AS "Comentari",
B.Resultat AS "StatusResult",
CASE WHEN (B.TS_USER_02 = 'Rendiment') THEN 'Automàtica'
ELSE CASE WHEN (B.TS_USER_02 <> 'Rendiment' and A.TS_TYPE = 'QUICKTEST-TEST') THEN 'Automàtica'
ELSE CASE WHEN (A.TS_TYPE <> 'QUICKTEST-TEST') THEN 'Manual'
END END END AS "Tipus Exec"
FROM
TEST A,
(
SELECT DISTINCT
rel_name,
TEST.TS_TEST_ID,
TEST.TS_NAME,
RELEASE_CYCLES.RCYC_NAME,
CYCLE.CY_CYCLE,
TEST.TS_USER_02,
TEST.TS_USER_01,
RUN.RN_TEST_ID,
DBMS_LOB.substr(RUN.RN_COMMENTS, 3000) AS Comentari,
//RUN.RN_COMMENTS AS "Comentari"
//DBMS_LOB.substr(TEST.TS_DEV_COMMENTS, 3000),
CASE WHEN (TEST.TS_EXEC_STATUS = 'Failed') THEN 'Failed' END AS Resultat,
TEST.TS_STATUS,
requisits,
CASE WHEN (TEST.TS_USER_01='Unitàries') THEN 1
ELSE CASE WHEN (TEST.TS_USER_01='Integració') THEN 2
ELSE CASE WHEN (TEST.TS_USER_01='Qualificació') THEN 3
ELSE CASE WHEN (TEST.TS_USER_01='Acceptació') THEN 4
ELSE CASE WHEN (TEST.TS_USER_01='Revisió') THEN 5
END END END END END AS NrNP
FROM TEST
LEFT JOIN testcycl on testcycl.tc_test_id=test.ts_test_id
LEFT JOIN run on run.rn_test_id = test.ts_test_id
LEFT JOIN cycle on cycle.cy_cycle_id=testcycl.tc_cycle_id
LEFT JOIN release_cycles on release_cycles.rcyc_id= cycle.cy_assign_rcyc
LEFT JOIN releases on releases.rel_id = release_cycles.rcyc_parent_id,
(SELECT TEST.TS_TEST_ID as req_prova_id, LISTAGG(REQ.RQ_REQ_ID, '; ') WITHIN GROUP (ORDER BY REQ.RQ_REQ_ID) AS requisits
FROM TEST
LEFT JOIN REQ_COVER on REQ_COVER.RC_ENTITY_ID=TEST.TS_TEST_ID
LEFT JOIN REQ on REQ_COVER.RC_REQ_ID=REQ.RQ_REQ_ID
GROUP BY TEST.TS_TEST_ID )
WHERE req_prova_id=TEST.TS_TEST_ID and RCYC_NAME=@Build@ and TEST.TS_EXEC_STATUS='Failed'
/* and TEST.TS_USER_02 <> 'Auditoria' and TEST.TS_USER_01 <>'Revisió' */
) B
WHERE A.TS_TEST_ID = B.TS_TEST_ID
ORDER BY B.RCYC_NAME, B.NrNP, B.TS_USER_02
Prémer ‘Query Builder’ i a la pestanya ‘Query Parameters’ de a sota, prémer el botó d’afegir paràmetre (
) i incloure un paràmetre amb el nom ‘Build’ amb el valor per defecte ‘0.0.0.B001’.
Des de la pestanya ‘Configuration’ situar-se a ‘Query’ i prémer el botó ‘Generate’.
Incrustar el fitxer generat en l’informe de resultats