Page 1 sur 1
how is it possible to view/print the differents executions of a same iteration?
Publié : mar. mai 03, 2016 3:10 pm
par i3s
Hi,
I refer my answer to the different rows I can see when I click on the 'NEW EXECUTION' botton of a test plan in the iteration item, so you can see in the add file.
It would be interesting to have these rows printed in an EXECUTION REPORT or in a DASHBORD, for example.
So, there is some possibility to have its?
Thanks a lot
how is it possible to view/print the differents executions of a same iteration?
Publié : mer. mai 04, 2016 2:06 pm
par GARENNE
Here is a query to answer this question :
SELECT project_0.NAME AS 'Nom Projet', campaign_library_node_0.NAME AS 'Nom Campagne', iteration_0.NAME AS 'Nom Itération', execution_0.NAME AS 'Nom Exécution', iteration_test_plan_item_0.EXECUTION_STATUS AS 'Statut Exécution', execution_step_0.COMMENT AS 'Commentaires', execution_step_0.EXECUTION_STEP_ID, execution_step_0.EXECUTION_STATUS AS 'Statut Pas Exécution', execution_step_0.LAST_EXECUTED_BY, execution_step_0.LAST_EXECUTED_ON, execution_execution_steps_0.EXECUTION_ID, execution_execution_steps_0.EXECUTION_STEP_ID, execution_0.EXECUTION_STATUS, execution_0.LAST_EXECUTED_BY, execution_0.LAST_EXECUTED_ON AS 'Date_Dernière_Exécution', iteration_0.ITERATION_ID, campaign_library_node_0.CLN_ID, campaign_library_node_0.PROJECT_ID
FROM squashtmdb.campaign_iteration campaign_iteration_0, squashtmdb.campaign_library_node campaign_library_node_0, squashtmdb.execution execution_0, squashtmdb.execution_execution_steps execution_execution_steps_0, squashtmdb.execution_step execution_step_0, squashtmdb.item_test_plan_execution item_test_plan_execution_0, squashtmdb.item_test_plan_list item_test_plan_list_0, squashtmdb.iteration iteration_0, squashtmdb.iteration_test_plan_item iteration_test_plan_item_0, squashtmdb.project project_0
WHERE execution_0.EXECUTION_ID = execution_execution_steps_0.EXECUTION_ID AND execution_execution_steps_0.EXECUTION_STEP_ID = execution_step_0.EXECUTION_STEP_ID AND item_test_plan_execution_0.EXECUTION_ID = execution_0.EXECUTION_ID AND iteration_test_plan_item_0.ITEM_TEST_PLAN_ID = item_test_plan_execution_0.ITEM_TEST_PLAN_ID AND campaign_iteration_0.ITERATION_ID = iteration_0.ITERATION_ID AND campaign_iteration_0.CAMPAIGN_ID = campaign_library_node_0.CLN_ID AND item_test_plan_list_0.ITERATION_ID = iteration_0.ITERATION_ID AND item_test_plan_list_0.ITEM_TEST_PLAN_ID = iteration_test_plan_item_0.ITEM_TEST_PLAN_ID AND project_0.PROJECT_ID = campaign_library_node_0.PROJECT_ID AND ((project_0.PROJECT_ID1))