question Report in App Engine forum

Report

daiva — Thu, 25 Jul 2024 05:44:18 GMT

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

Re: Report

Mark Manders — Thu, 25 Jul 2024 08:08:20 GMT

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.

Re: Report

daiva — Thu, 25 Jul 2024 09:25:33 GMT

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.

Re: Report

Mark Manders — Fri, 26 Jul 2024 07:40:15 GMT

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?

Re: Report

daiva — Tue, 30 Jul 2024 05:42:24 GMT

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);

Re: Report

Mark Manders — Tue, 30 Jul 2024 08:49:17 GMT

Mark all the old ones as 'old' and then this should do the trick from now on:

//Only trigger on insert, because it only needs to run once var oldTest = new GlideRecord('sys_atf_test_suite_result'); oldTest.addQuery('u_test_state','new'); oldTest.query(); if(oldTest.next()){ oldTest.setValue('u_test_state','old'); oldTest.update(); } current.u_test_state = 'new'; current.update(); // depending on your conditions is the update is needed

Re: Report

daiva — Tue, 30 Jul 2024 10:39:05 GMT

Not working
Can you please Suggest me some other
It's not changing to any state It is leaving blank.

Re: Report

daiva — Mon, 05 Aug 2024 12:49:28 GMT

Hello @Mark Manders

Test Suite Results Table contains Suites and when this suite run the Test State has to Update Dynamically to New when the New result is Created and the Older Results need to set state "Old" using Flow Designer.