General Test Plan Metrics

noki88 · Post by **noki88** » Thu Oct 21, 2010 12:20 pm

Environment:

MySql 5.1.41
Apache 2.2.14 (Win32)
PHP 5.3.1
TestLink 1.9 RC 1

The calculation "Not Run" in General Test Plan Metrics does not work or very slow if a user assigned to cases:

Steps To Reproduce

Create a test suite
Create 6 test cases
Create a test plan
Add test cases to test plan
Create a build
Do not assign user to a test case
Execute two cases as "Passed"
Goto General Test Plan Metrics

The sql command to calculate "Not Run" will result 0:
SELECT COUNT(UA.id) FROM testlink_1_9_rc1_mod.user_assignments UA
LEFT OUTER JOIN testlink_1_9_rc1_mod.testplan_tcversions TPTCV ON UA.feature_id = TPTCV.id
LEFT OUTER JOIN testlink_1_9_rc1_mod.executions E ON TPTCV.tcversion_id = E.tcversion_id AND UA.build_id = E.build_id AND TPTCV.platform_id = E.platform_id
WHERE UA.build_id = 1 AND E.status IS NULL AND UA.type = 1

I think the select must be only over testplan_tcversions and executions.

Excuse my bad English!