OnChange client script to revert state to new

[Community Alums]

Hi everyone I had a requirement asking there needs to be a check that the risk has been assessed before progressing to the Assess state. This could be a check on the existence of a change risk detail record, so that the change cannot progress without risk having been assessed. An onChange client script on change of state to Assess with an Ajax lookup of the change risk detail records would work for this - putting the state field value back to New if the risk assessment hasn't been run

[Dr Atul G- LNG]

Hi @Community Alums 

For this, write a code on Assess UI action, to check if the Risk Assessment exits or not, if not don't move the change to Next state.

I guess it is OOTB avail. 

https://www.servicenow.com/community/developer-forum/ui-action-validation-before-process-the-action/m-p/2113495

https://www.servicenow.com/community/developer-forum/auto-checking-if-risk-assessment-form-is-not-yet-filled-out/m-p/1581288

[Amit Gujarathi]

HI @Community Alums ,
I trust you are doing great.
Please find the below scripts for the same :
Client script :

// Client Script - Type: onChange
// Field Name: state (adjust according to your field name)

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue === '') {
        return;
    }

    // Check if state is changing to 'Assess'
    var targetState = 'Assess'; // Replace with the appropriate value or sys_id of the Assess state
    if (newValue === targetState) {
        // Perform AJAX to check for risk assessment
        var ga = new GlideAjax('CheckRiskAssessment');
        ga.addParam('sysparm_name', 'hasRiskAssessment');
        ga.addParam('sysparm_change_sys_id', g_form.getUniqueValue());
        ga.getXML(checkRiskResponse);
    }
}

function checkRiskResponse(response) {
    var answer = response.responseXML.documentElement.getAttribute("answer");
    if (answer === 'false') {
        // Revert state to 'New' and alert the user
        g_form.setValue('state', 'New'); // Replace 'New' with the appropriate value or sys_id
        alert('Risk assessment is required before progressing to Assess.');
    }
}

And the corresponding Script Include:

// Script Include
var CheckRiskAssessment = Class.create();
CheckRiskAssessment.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    
    hasRiskAssessment: function() {
        var changeSysId = this.getParameter('sysparm_change_sys_id');
        var riskAssessmentFound = false;

        // Query the change risk detail table to check for associated records
        var gr = new GlideRecord('change_risk_detail'); // Replace with your table name
        gr.addQuery('change_record', changeSysId);
        gr.query();

        if (gr.next()) {
            riskAssessmentFound = true;
        }

        return riskAssessmentFound;
    },

    type: 'CheckRiskAssessment'
});