Report

[daiva]

Hello Community,

1)I need to Create a Report that shows the Test Results Failure and Success Status in the Report.
My Requirement is to show the Latest Run Results and the results need to freeze and next time when i run the Test Suite it need to show me the Newly Run Test Suite Results in the Report and the Old Results should not Show these New need to be shown till i run test Suite.
How can i Achieve this Functionality?

2)Can i able to Add a Custom Button on the Dashboard?

Thanks,
Daiva

[Mark Manders]

You can't do that through the conditions, unless you have some functionality on your run showing it's the last one so you can filter to it.

But if you put it on a dashboard, you can put a filter on it as well to select the run or the date. It will also give you the possibility to compare.

What kind of button do you need? Moving to Platform Analytics (especially in the technical builder) gives a lot of possibilities, but it's depending on your use case.

[daiva]

Could You Please specify what type of Conditions Should i Use

MY Requirement is:
Test.Name is Quote 
this has to to Show currently Run Test Results 
When New is Run Old should not Show.

[Mark Manders]

To be able to tell you what conditions to use, you will need to answer my question: is there any functionality that tells you the run is the last one?

[daiva]

Hello @Mark Manders 

I'm not able to do with the filter, so i have a new approach towards it.
New & Old Choice Fields Created to the 
Test Suite Result [sys_atf_test_suite_result] Table 
A Business Rule.
When Record is Inserted The State = new
the Older records = old
This works as a Loop

I used this as the Filter Condition in the Reports 
Test Suite.Test state       is         New
But my script is Not working Properly could you please Help me with this Script

When: Before
Inserted 
Updated

(function executeRule(current, previous /*null when async*/) {

//     // Set the state of the new record to "new"

 if (current.isNewRecord() || current.number != previous.number) {

//         // Set the state to New for the new test suite result

       current.u_test_state = 'new';

//         // Query to find all previous test suite results

     previous.addQuery('sys_id', '!=', current.sys_id); // Exclude the current record

       previous.query();

        while (previous.next()) {

//             // Set the state to Old for all previous test suite results

            previous.u_test_state = 'old';

           previous.update();

       }

 }

})(current, previous);