Hi,
Thanks for the wonderful tool.
We are using Testlink tool version 1.6.2.
I have introduced new table to capture execution time for each suite.
This table has testername, date,projectID,component ID and product ID.
Now I want to link this with results table of Testlink.
This is required to collect datewise data on test cases executed, pass fail,blocked and efforts.
Can someone help me out with a suitable query
Here is the code I currently have.
SELECT mgtproduct.name as product,mgtcomponent.name as Component,
count(*) as Total, COUNT( IF( status = 'p', 1, NULL ) ) as Passed,
COUNT( IF( status = 'f', 1, NULL ) ) as Failed, " COUNT( IF( status = 'b', 1, NULL ) ) as Blocked, COUNT( IF( status = 'n', 1, NULL ) ) as NotRun,
sum(efforts.effort) as 'Efforts in PHrs.'
FROM results, build,project,mgtproduct, mgtcomponent, component,
category, testcase, efforts
where results.build_id = build.id And build.projid = project.id And
project.prodid = mgtproduct.id And results.tcid = testcase.id And
testcase.catid = category.id And category.compid = component.id
And efforts.id = component.id And component.mgtcompid =
mgtcomponent.id And mgtproduct.id = '" . $SESSION_productID
GROUP BY mgtproduct.name, mgtcomponent.name