Project Reports

[flanlg]

Hello,

I've installed version 1.9 (Prague) and I'm doing a series of tests to see the possibilities offered by the tool in the face of mining reports and dashboards using various tools (BIRT, etc.).

I'm having problems when getting reporting of requirements, test cases if you want to structure the project.

Can you comment on whether there is any chance of filtering by project the results of queries that can be made ​​to the database Testlink? I put examples of queries that I'm trying and obviously provide no information on the project.

select count (distinct executions.id), count (distinct req_coverage.testcase_id)
from executions, req_coverage

requirements.req_doc_id SELECT count (req_coverage.testcase_id)
FROM requirements, req_coverage, testprojects
WHERE requirements.id = req_coverage.req_id
GROUP BY requirements.id


Thank you very much.

[flanlg]

Sorry, there is a typo in the following sentence:
"I'm having problems when getting reporting of requirements, test cases if you want to structure the project." =>"I'm having problems when getting reporting of requirements, test cases if you want to structure them by project