Forum SquashTM

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

Can anybody support me? I really appreciate any support. thank you.

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.

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