It's all about the answers!

Ask a question

How can i get list of test cases executed on a particular day?

Shaji Narayanan (132) | asked Feb 11 '16, 7:53 a.m.
 I want to have a dashboard with list and count of test cases on a particular day...

Can some one suggest the best way to achieve this?

Accepted answer

permanent link
Don Yang (7.6k21100135) | answered Feb 11 '16, 6:16 p.m.
edited Feb 11 '16, 6:19 p.m.
Hi, Shaji

The simplest way is to create a Test Case Execution Record(TCER) query.
You can go to TCER view and add column 'Last Result Completed'.
Then add a filter to this column(set a specific day) and save the query(Run the query to see
the result is expected or not).
Then in the dashboard, you can add widget 'Execution Records Query' and set the above
query to it.
It will show the total number executed and you can hover it to see the list of test cases.
It would look like:


Another option is to use JRS if you are on v5.0.2 or later.(RRDI or custom Birt reports could achieve the same but JRS would be the easiest)

I hope this helps.

Shaji Narayanan selected this answer as the correct answer

Shaji Narayanan commented Feb 15 '16, 1:53 a.m.

Hi Don Yan,
Thank you very much for the response...
Is there anyway I can get the cases executed today without changing the query everyday?

Don Yang commented Feb 15 '16, 2:47 a.m.

Hi, Shaji

If you use JRS report, you can specify Today attribute, but query does not have Today option hence you can only specify a date or relative date(for example, 1 day ago etc).

One other answer

permanent link
Shaji Narayanan (132) | answered Feb 15 '16, 1:53 a.m.
edited Feb 15 '16, 3:28 a.m.

Your answer

Register or to post your answer.