Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.
 

Reports: Is there a way to get weekly data from a project


#1

Out TestRail project contains multiple TestPlans and TestRuns. I want to get weekly data(of no of test cases passed , failed, etc…) for each TestPlan/TestRun in the project. With this i should be able to read the week1 to weekn data of each TestPlan or TestRun in TestRail project.

If this is not possible from UI. Is there a way to do with APIs?(something like /get_plan/& from_date=XX&to_date=YY)


#2

Hi Aditya,

Thanks for your posting. Yes, you can either use the API or the reports from the Reports in this case. To read the plans, runs & results via the API, you can use get_plans, get_runs & get_results:

http://docs.gurock.com/testrail-api2/reference-plans
http://docs.gurock.com/testrail-api2/reference-runs
http://docs.gurock.com/testrail-api2/reference-results

To create reports instead, you can take a look at the Summary > Runs, Summary > Plans and Summary > Project on the Reports tab, for example.

Cheers,
Tobias


#3

Thanks Tobias. I went through API references, but i am not finding request filters for from_date and to_date. I am seeing request filters created_before and created_after but they are not helpful for my use case. My use case is to find activity on testplan/testrun week over week


#4

Hi Aditya,

There are two options in this case. The simplest/most efficient one would be to use the created_before / created_after filters and this is is a good fit if you constantly create new test plans/runs. If your plans/runs are active for a longer period of time and you add results to the same plans/runs, you can also get_results_for_run to get the activity per test run:

http://docs.gurock.com/testrail-api2/reference-results

If possible though, we would recommend using the reports from the Reports tab and the Summary > Projects and Summary > Runs/Plan reports would be a good fit.

Cheers,
Tobias