OnChange Client script not working on SC_TASK table

anerivirani19
Tera Contributor

‎06-12-2025 02:49 PM

Hello there, 
 
Below client script on sc_task table doesn't seem to work. Please help 🙂
Type: On Change
Application:Global
Field Name: State
 
Requirements: I have dependent variables like Yes/No. If yes, attachment needs to be provided and when no reasoning needs to be given. All the variables of the task should be mandatory on closure. They're not mandatory on Save. 
 
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (g_form.getValue('state') == 3 ) {
       
           if(g_form.getValue('short_description').startsWith("Add to Inventory Service and Review attached Health Check") { 
   
        g_form.setMandatory('n_act_Initial_compliance_validation_on_configuration_item_question', true);
        if (g_form.getValue('n_act_Initial_compliance_validation_on_configuration_item_question') == 'yes') {
            g_form.setMandatory('n_act_evidence_Initial_compliance_validation_on', true);
        }
        if (g_form.getValue('n_act_Initial_compliance_validation_on_configuration_item_question') == 'no') {
            g_form.setMandatory('n_act_no_reason_Initial_compliance_validation_on', true);
        }
        g_form.setMandatory('n_act_configuration_item_in_appropriate_security_inventory_databases_question', true);
        if (g_form.getValue('n_act_configuration_item_in_appropriate_security_inventory_databases_question') == 'yes') {
            g_form.setMandatory('n_act_evidence_configuration_item_in_appropriate_security_inventory_databases', true);
        }
        if (g_form.getValue('n_act_configuration_item_in_appropriate_security_inventory_databases_question') == 'no') {
            g_form.setMandatory('n_act_no_reason_configuration_item_in_appropriate_security_inventory_databases', true);
        }
        g_form.setMandatory('n_act_lifecycle_status', true);
        g_form.setMandatory('n_act_business_need_required', true);
        g_form.setMandatory('n_act_userid_process_required', true);
        g_form.setMandatory('n_act_employment_verification_required', true);
        g_form.setMandatory('n_act_health_check_required', true);
        g_form.setMandatory('n_act_manual_health_check_required', true);
        g_form.setMandatory('n_act_non_privileged_revalidation_required', true);
        g_form.setMandatory('n_act_privileged_revalidation_required', true);
        g_form.setMandatory('n_act_software_collection_required', true);
        g_form.setMandatory('n_act_opaque_id', true);
        g_form.setMandatory('n_act_bac_id', true);
        g_form.setMandatory('n_act_bam_id', true);
        g_form.setMandatory('n_act_compliance_reporting', true);
        g_form.setMandatory('n_act_parent_system_type', true);
        g_form.setMandatory('n_act_operating_system_release', true);
        g_form.setMandatory('n_act_security_managed_by', true);
        }
    } else {
        if (g_form.getValue('short_description').startsWith("Add to Inventory Service and Review attached Health Check")) {
       g_form.setMandatory('n_act_Initial_compliance_validation_on_configuration_item_question', false);
      if (g_form.getValue('n_act_Initial_compliance_validation_on_configuration_item_question') == 'yes') {
            g_form.setMandatory('n_act_evidence_Initial_compliance_validation_on', false);
       }
        if (g_form.getValue('n_act_Initial_compliance_validation_on_configuration_item_question') == 'no') {
          g_form.setMandatory('n_act_no_reason_Initial_compliance_validation_on', false);
     }
       g_form.setMandatory('n_act_configuration_item_in_appropriate_security_inventory_databases_question', false);
         if (g_form.getValue('n_act_configuration_item_in_appropriate_security_inventory_databases_question') == 'yes') {
           g_form.setMandatory('n_act_evidence_configuration_item_in_appropriate_security_inventory_databases', false);
    }
         if (g_form.getValue('n_act_configuration_item_in_appropriate_security_inventory_databases_question') == 'no') {
            g_form.setMandatory('n_act_no_reason_configuration_item_in_appropriate_security_inventory_databases', false);
         }
        g_form.setMandatory('n_act_lifecycle_status', false);
        g_form.setMandatory('n_act_business_need_required', false);
        g_form.setMandatory('n_act_userid_process_required', false);
        g_form.setMandatory('n_act_employment_verification_required', false);
        g_form.setMandatory('n_act_health_check_required', false);
        g_form.setMandatory('n_act_manual_health_check_required', false);
        g_form.setMandatory('n_act_non_privileged_revalidation_required', false);
        g_form.setMandatory('n_act_privileged_revalidation_required', false);
        g_form.setMandatory('n_act_software_collection_required', false);
        g_form.setMandatory('n_act_opaque_id', false);
        g_form.setMandatory('n_act_bac_id', false);
        g_form.setMandatory('n_act_bam_id', false);
        g_form.setMandatory('n_act_compliance_reporting', false);
        g_form.setMandatory('n_act_parent_system_type', false);
        g_form.setMandatory('n_act_operating_system_release', false);
        g_form.setMandatory('n_act_security_managed_by', false);
    }
     }
}
0 Helpfuls
  • 515 Views
4 REPLIES 4

Bert_c1
Kilo Patron

‎06-12-2025 03:13 PM

I see you are checking for state = 3 if the first "if" which is 'Closed Complete', the "else" logic applies to all others. But there are also "Closed Incomplete" and "Closed Skipped". Maybe that is intentional. Also, the above doesn't address requiring an attachment that I can see.  Anyway, I would add "alert()' statements in the script to see items of interest to help you debug.

Chaitanya ILCR
Kilo Patron

‎06-12-2025 05:29 PM

Hi @anerivirani19 ,

 

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
 
    var shortDesc = g_form.getValue('short_description');
    var isTargetShortDesc = shortDesc && shortDesc.startsWith("Add to Inventory Service and Review attached Health Check");

    if (newValue == '3' && isTargetShortDesc) {
        g_form.setMandatory('n_act_Initial_compliance_validation_on_configuration_item_question', true);

        if (g_form.getValue('n_act_Initial_compliance_validation_on_configuration_item_question') == 'yes') {
            g_form.setMandatory('n_act_evidence_Initial_compliance_validation_on', true);
        } else if (g_form.getValue('n_act_Initial_compliance_validation_on_configuration_item_question') == 'no') {
            g_form.setMandatory('n_act_no_reason_Initial_compliance_validation_on', true);
        }

        g_form.setMandatory('n_act_configuration_item_in_appropriate_security_inventory_databases_question', true);

        if (g_form.getValue('n_act_configuration_item_in_appropriate_security_inventory_databases_question') == 'yes') {
            g_form.setMandatory('n_act_evidence_configuration_item_in_appropriate_security_inventory_databases', true);
        } else if (g_form.getValue('n_act_configuration_item_in_appropriate_security_inventory_databases_question') == 'no') {
            g_form.setMandatory('n_act_no_reason_configuration_item_in_appropriate_security_inventory_databases', true);
        }

        var mandatoryVars = [
            'n_act_lifecycle_status',
            'n_act_business_need_required',
            'n_act_userid_process_required',
            'n_act_employment_verification_required',
            'n_act_health_check_required',
            'n_act_manual_health_check_required',
            'n_act_non_privileged_revalidation_required',
            'n_act_privileged_revalidation_required',
            'n_act_software_collection_required',
            'n_act_opaque_id',
            'n_act_bac_id',
            'n_act_bam_id',
            'n_act_compliance_reporting',
            'n_act_parent_system_type',
            'n_act_operating_system_release',
            'n_act_security_managed_by'
        ];

        mandatoryVars.forEach(function(v) {
            g_form.setMandatory(v, true);
        });

    } else if (isTargetShortDesc) {
        // Reset all to non-mandatory
        var allVars = [
            'n_act_Initial_compliance_validation_on_configuration_item_question',
            'n_act_evidence_Initial_compliance_validation_on',
            'n_act_no_reason_Initial_compliance_validation_on',
            'n_act_configuration_item_in_appropriate_security_inventory_databases_question',
            'n_act_evidence_configuration_item_in_appropriate_security_inventory_databases',
            'n_act_no_reason_configuration_item_in_appropriate_security_inventory_databases',
            'n_act_lifecycle_status',
            'n_act_business_need_required',
            'n_act_userid_process_required',
            'n_act_employment_verification_required',
            'n_act_health_check_required',
            'n_act_manual_health_check_required',
            'n_act_non_privileged_revalidation_required',
            'n_act_privileged_revalidation_required',
            'n_act_software_collection_required',
            'n_act_opaque_id',
            'n_act_bac_id',
            'n_act_bam_id',
            'n_act_compliance_reporting',
            'n_act_parent_system_type',
            'n_act_operating_system_release',
            'n_act_security_managed_by'
        ];

        allVars.forEach(function(v) {
            g_form.setMandatory(v, false);
        });
    }
}

try this script and adjust it if required

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

0 Helpfuls

WillieW
Tera Contributor
In response to Chaitanya ILCR

‎06-13-2025 11:50 AM

how does re-structuring the code that results in the same outcome help?

0 Helpfuls

Rafael Batistot
Tera Sage

‎06-12-2025 06:38 PM

Hi @anerivirani19, 

 

Why Not Use UI Policies Instead of Client Scripts?
Instead of using Client Scripts with onChange, you should really consider using a UI Policy for this.
A UI Policy lets you define which fields will be mandatory or not, and the best part is, you won't need to write any script! A UI Policy is generally a much better fit for this kind of scenario.

0 Helpfuls