I have a simple question. Can anyone help please?
I need mysql database query that shows:
Iteration date |
Iteration Test case (name of test case) |
Iteration execution result |
in another words, I need the sql query (mySQL) that provides the data shown in Iteration Execution Plan page
check below screenshot as an example for page "/squash/campaign-workspace/":
https://prnt.sc/v2qy1j
(also attached)
thank you
Iteration MySQL Query
Iteration MySQL Query
- Pièces jointes
-
- "/squash/campaign-workspace/"
- download.png (250.27 Kio) Consulté 2036 fois
Re: Iteration MySQL Query
Can anybody support me? I really appreciate any support. thank you.
Re: Iteration MySQL Query
i doubt if it is the right place i posted this query? I'm not getting any response.
@admin please help me knocking the right door.
@admin please help me knocking the right door.
Re: Iteration MySQL Query
Bonjour,
Voici une requête Postgresql plutôt (à transposer pour Mysql) :
select tc.*, p.name, e.*
from execution e, item_test_plan_execution itpe, test_case_library_node tcln, project p, test_case tc
where e.execution_id in
(select itpe.execution_id from item_test_plan_execution itpe where itpe.item_test_plan_id in
(select itpl.item_test_plan_id from item_test_plan_list itpl where itpl.iteration_id=...)
)
and e.execution_id=itpe.execution_id
and e.tcln_id=tcln.tcln_id
and e.tcln_id=tc.tcln_id
and p.project_id=tcln.project_id
order by itpe.item_test_plan_id
Bonne réception
Voici une requête Postgresql plutôt (à transposer pour Mysql) :
select tc.*, p.name, e.*
from execution e, item_test_plan_execution itpe, test_case_library_node tcln, project p, test_case tc
where e.execution_id in
(select itpe.execution_id from item_test_plan_execution itpe where itpe.item_test_plan_id in
(select itpl.item_test_plan_id from item_test_plan_list itpl where itpl.iteration_id=...)
)
and e.execution_id=itpe.execution_id
and e.tcln_id=tcln.tcln_id
and e.tcln_id=tc.tcln_id
and p.project_id=tcln.project_id
order by itpe.item_test_plan_id
Bonne réception