Page History

...

If you are using manual tests only (test scripts) or do not have a Duette license - , then this can often by be achieved by just using a "GROUP BY" on the Status status of script assignments:

GROUP BY Status { COUNT } WHERE EntityType = ScriptAssignment

But if If you are using Duette and have a mix of automated and manual test results, you will often want to get a combined view of progress across them both - to all tests. To do this, you can use the following "Total" fields.

...

• Assignments Count
• Attachment Count
• Automated Tests Count
• Incident Count
• Iterations
• Requirements Count
• Script Step Count
• Test Scripts Count
• Total Nodes
• Total Results

How They are

...

Calculated

For automated tests, these fields will provide counts , as present in the imported result files.

For manual tests (test scripts) these counts will have a value of either 0 or 1, if the status matches the type of the field, this also means that some counts (such as Warnings, Errors, Iterations etc.) will always be 0, as they are not supported as possible outcomes for a script assignment (manual test).

...

SUM(InProgress) AS 'In Progress', 
SUM(Undetermined) AS 'Undetermined',
SUM(Errors) AS 'Errors', 
SUM(Failed) AS 'Failed', 
SUM(NotRun) AS 'Not Run', 
SUM(Passed) AS 'Passed', 
SUM(Skipped) AS 'Skipped', 
SUM(Warnings) AS 'Warnings', 
SUM(Blocked) AS 'Blocked'
WHERE Project = 'Project X' 
  AND Package = 'Cycle 1'

And here Here is what the results will look like:

...

FACETED OrArgs(GreaterThan(Errors,0), GreaterThan(Warnings,10)) AS "Require Review", 
Unmatched() AS "OK" { COUNT }
WHERE EntityType = TestAssignment

And here Here is what the results will look like for that query:

...