Iteration MySQL Query

zakwithu2
Messages : 4
Inscription : mar. oct. 20, 2020 4:57 am

Iteration MySQL Query

Message par zakwithu2 »

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
Pièces jointes
"/squash/campaign-workspace/"
"/squash/campaign-workspace/"
download.png (250.27 Kio) Consulté 1981 fois
zakwithu2
Messages : 4
Inscription : mar. oct. 20, 2020 4:57 am

Re: Iteration MySQL Query

Message par zakwithu2 »

Can anybody support me? I really appreciate any support. thank you.
zakwithu2
Messages : 4
Inscription : mar. oct. 20, 2020 4:57 am

Re: Iteration MySQL Query

Message par zakwithu2 »

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.
injeim
Messages : 29
Inscription : mer. oct. 10, 2018 2:44 pm

Re: Iteration MySQL Query

Message par injeim »

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
Répondre

Revenir à « Installation & Base de données / Installation & Database »